Date Time Conversion
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello I am trying to convert the scheduled and actual dates in the attached filed to be in the format of - YYYY-MM-DD hh:mm:ss. The date time parse tools I currently have on there are only coming back with NULL values. I have also tried to use the datetimeparse formula and have still gotten only NULLS returned.
Any help would be greatly appreciated!
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dougop use the DateTimeParse formula like below for each date fields
https://help.alteryx.com/20214/designer/datetime-functions
DateTimeParse([Scheduled Start],'%b %d, %Y %I:%M %p')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you want to use the datetime tool, you can use this format as well
Mon dd, yyyy %I:%M %P
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dougop The null values are because of the format you have specified in the DateTimeParse function as well as the DateTimeParse tool. The general idea is that the format that you mention should match the incoming data stream. The formula that @binuacs has mentioned matches your incoming date.
Please check the below link for more information of how date can be formatted using these functions:-
https://help.alteryx.com/20214/designer/datetime-functions
Also within your workflow it looks like you are converting multiple dates. You can do all of that in one formula tool. Thereby avoiding multiple tools. Please find attached a workflow showcasing that.
Hope this helps!
Best,
Jagdeesh
