Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
su_pyae
Creator
Creator

Changing ReloadTime() from Germany Time zone to New York Time zone

Hello everyone, 

I am having issues with converting my reload time to New York Time Zone. 

My reload time is always in Germany Time Zone. I am using this formula to change it into New York Time Zone: Time(ConvertToLocalTime(ReloadTime(), 'GMT-04:00'),'h:mm TT')

For example, I reloaded my data at 1:55 PM (my time) but when I use ReloadTime(), it will give me 10:55 PM which is the data reload time, using Germany Time Zone. 

When I convert it using 'GMT-04:00' to get it in NY time, 6:55 PM which is wrong. It should be 4:55 PM since CA and NY have only 3 hours difference and NY and Germany have 6 hours difference. 

Please let me know what I did wrong. 

Thank you!

Labels (3)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

its 6hrs difference so it shoudl be GMT-6

=Time(ConvertToLocalTime(ReloadTime(), 'GMT-06:00'),'h:mm TT')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

its 6hrs difference so it shoudl be GMT-6

=Time(ConvertToLocalTime(ReloadTime(), 'GMT-06:00'),'h:mm TT')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.