Date Time 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
727
7 - Meteor
‎04-12-2021
10:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
One of the date fields from my excel input appears as decimals (e.g. 44258.469444444). How do I convert this to MM/DD/YYYY? TIA
Labels:
- Labels:
- Date Time
3 REPLIES 3
17 - Castor
‎04-12-2021
10:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @727
You can use the attached as an example on how to do this.
- I take the 'floor' of the value, which rounds down and just gets the whole number. The decimals here represent time which is not needed based on your post.
- The excel number represents number of days since 1900. You can use the datetimeadd function to add that number to 1/1/1900. We need to subtract 2 here due to some nuances with leap years and how the date functionality works.
Hope this helps!
21 - Polaris
‎04-12-2021
04:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎04-12-2021
04:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Qiu - much simpler!
