function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
DCBoyDCBoy 

DateTime to Text

Hi, 

I have a datetime field and need to use it in a formula field. When I use TEXT( ClosedDate ) it outputs the time like this 2011-07-22 21:32:48Z. What does the word "Z" mean in this output and what time zone is it in? My org is in North America, the user is in Pacific Time Zone and the output seems like GMT but am not sure coz I was expecting 8 hours to be the difference between PST and GMT.

 

Is there a way to display datetime in user's time zone in a formula field?

 

Thanks in adv.

Sean C.ax1056Sean C.ax1056

Hey DCBoy

 

There's an answer here which may help:

 

http://success.salesforce.com/questionDetail?qId=a1X30000000Hov6EAC