SOLVED
Serial date to calendar date time in a custom format
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
Jsan2758
6 - Meteoroid
‎04-09-2020
11:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I need help in converting a serial date time (input as string or double) to a calendar date time in the following custom format yyyy-mm-ddThh:mmZ.
I tried DateTimeAdd function but it just doesn’t pick up the actual hours and minutes.
I also tried the date time tool but having trouble with string / date time fields.
thanks
Solved! Go to Solution.
4 REPLIES 4
DavidP
17 - Castor
‎04-10-2020
12:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you post samples of your input data and desired output format.
‎04-10-2020
01:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
the input is 43735.5919097222 (double or string)
the output: 2019-09-27T14:12Z
thanks heaps
DavidP
17 - Castor
‎04-10-2020
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-10-2020
06:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! It works.