timestamp

[qvqfqlik]

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

[sunny_talwar]

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

[OmarBenSalem]

Juste use localTime()

[qvqfqlik]

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

I also need CST at the end

[qvqfqlik]

I need to print date  time and timezone

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

[sunny_talwar]

May be just add it like this

LocalTime(now()) & ' CST'

[Anil_Babu_Samineni]

Perhaps this?

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

[qvqfqlik]

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

[qvqfqlik]

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

[qvqfqlik]

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

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