Convert GMT timestamp values into EST

[Anonymous]

Hi All,

  In my DB having values stored in GMT time zone. So the dashboard reflects the same. However user who in EST time zone needs to view the reports in EST format. How to achieve this.

-Jay

[Anonymous]

Hi,

Try:

ConvertToLocalTime(FieldName, 'EST') 

[arulsettu]

try like this

ConvertToLocalTime('GMT'-6)

[morganaaron]

Think it's quite fussy over syntax, so try:

=ConvertToLocalTime([Your Field], 'Eastern Time (US & Canada)')

[Anonymous]

or

try:

ConvertToLocal(Fieldname, 'GMT-6:00')