topic Re: Convert GMT timestamp values into EST in QlikView

Convert GMT timestamp values into EST

Anonymous — Thu, 29 Jan 2015 11:06:57 GMT

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

Re: Convert GMT timestamp values into EST

Anonymous — Thu, 29 Jan 2015 11:12:08 GMT

Hi,

Try:

ConvertToLocalTime(FieldName, 'EST')

Re: Convert GMT timestamp values into EST

arulsettu — Thu, 29 Jan 2015 11:12:48 GMT

try like this

ConvertToLocalTime('GMT'-6)

Re: Convert GMT timestamp values into EST

morganaaron — Thu, 29 Jan 2015 11:21:32 GMT

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

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

Re: Convert GMT timestamp values into EST

Anonymous — Thu, 29 Jan 2015 11:28:49 GMT

try:

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