Date Time Conversion

[dougop]

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!

[binuacs]

@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')

[SPetrie]

If you want to use the datetime tool, you can use this format as well

Mon dd, yyyy %I:%M %P

[JagdeeshN]

@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