SOLVED
Epoch time to Your time zone
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AKPWZ
8 - Asteroid
‎05-24-2023
09:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
The problem I'm facing right now is this:
When I'm converting epoch time into DateTime using this formula "DateTimeAdd('1970-01-01',[date]/1000, 'Seconds')" I'm getting the GMT value (marked yellow), but in actual I need "Your TIme Zone" value (marked blue).
Can you please help me to solve this issue. Thank you!
Solved! Go to Solution.
Labels:
2 REPLIES 2
FrederikE
13 - Pulsar
‎05-25-2023
03:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @AKPWZ,
You only need to convert GMT to your time. Therefore
DateTimeAdd([DateTime],5.5*60,'minutes') should do it.
‎05-25-2023
03:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thats awesome @FrederikE thank you so much!