Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

priqvqlik
Contributor

timestamp

Please help with how to get local time zone in the timestamp

I used ConvertToLocalTime(now())  , but this doesnt seem to be working

eg: 10/19/2017  8:15 AM  EST

21 Replies

Re: timestamp

What is the issue? The time zone is not correct?

OmarBenSalem
Esteemed Contributor

Re: timestamp

Juste use localTime()

priqvqlik
Contributor

Re: timestamp

localtime() just gives as 10/19/2017 9:00 AM

I also need CST at the end

priqvqlik
Contributor

Re: timestamp

I need to print date  time and timezone

eg: 10/19/2017 9:00 AM  CST

Re: timestamp

May be just add it like this

LocalTime(now()) & ' CST'

Re: timestamp

Perhaps this?

=ConvertToLocalTime(UTC(Now()), 'GMT-05:00')

Life is so rich, and we need to respect to the life !!!
priqvqlik
Contributor

Re: timestamp

still this doesnt show timezone like cst/est/pst etc

priqvqlik
Contributor

Re: timestamp

it should dynamically show the time zone based on user system time

eg:  if a user in EST

10/19/2017 11:00 AM EST

10/19/2017 10:00 AM CST

priqvqlik
Contributor

Re: timestamp

still this doesnt show timezone like cst/est/pst /ist/gmt 


I got it as 10/19/2017 10:00 AM

Community Browser