Date change from Jan 10, 2023 5:45 AM to Alteryx readable date format

[ag72]

Hello, 

I have my dates in the format of "Jan 10, 2023 5:45 AM" so how to change into the Alteryx readable date format so that later on I can apply different filters in Alteryx?

Thanks

[ShankerV]

Hi @ag72 

If you are looking for the date format to be changed, below is one way of doing this.

Many thanks

Shanker V

[DataNath]

Hey @ag72, there's a couple ways to do this but I always like the DateTimeParse() method:

DateTimeParse([Input],'%b %d, %Y %I:%M %p')