+ Start a Discussion
selvakumar Anbazhaganselvakumar Anbazhagan 

"CreatedDate" Formula conversion GMT Timezone Issue

Hi All,

I need to create a new custom Text formula  for "createdDate". When i converting my date has been changed to GMT timezone. But actually my region belongs to EST US Timezone. SO it converting it 4Hrs behind of actual time. How i can sort out this thing. Any help on this.

My formula is given below.


I have even tried as TEXT(DATEVALUE(CreatedDate + ( 4 * 0.04167))) . But it doesn't work.

Thanks in advance.
Ajay K DubediAjay K Dubedi
Hi Selvakumar,
As you are in EST and there is a +4h difference with GMT

So you should use this:

1 day/24h = 0.0416666666 (value of 1 hour)

0.041666666(value of 1 hour) x 4 (how many hours difference my timezone to GMT) = 0.166666664

then you have to subtract this value from the formula, instead of adding it . You can also refer to this link:
https://help.salesforce.com/apex/HTViewSolution?id=000005091&language=en_US (https://help.salesforce.com/apex/HTViewSolution?id=000005091&language=en_US)