You need to sign in to do that
Don't have an account?
DCBoy
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.
Hey DCBoy
There's an answer here which may help:
http://success.salesforce.com/questionDetail?qId=a1X30000000Hov6EAC