Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the issue? The time zone is not correct?
Juste use localTime()
localtime() just gives as 10/19/2017 9:00 AM
I also need CST at the end
I need to print date time and timezone
eg: 10/19/2017 9:00 AM CST
May be just add it like this
LocalTime(now()) & ' CST'
Perhaps this?
=ConvertToLocalTime(UTC(Now()), 'GMT-05:00')
still this doesnt show timezone like cst/est/pst etc
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
still this doesnt show timezone like cst/est/pst /ist/gmt
I got it as 10/19/2017 10:00 AM