community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Convert text date to date

Asteroid

 

Here are my sample dates

 

Monday, November 5, 2018 8:38 AM
Wednesday, October 10, 2018 2:51 PM

 

How can I get them converted into below format

2018-11-05
2018-10-22

 

Alteryx Certified Partner

Here's the formula used to parse that format:

 

DateTimeParse([Input],"%A, %B %d, %Y %I:%M %p")

 

I recommend keeping this page bookmarked:

https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm

Alteryx Certified Partner
Alteryx Certified Partner

Hi @mszpot89

 

 

Sorry I had not seen Charlie's reply.

I'd add the DateTimeFormat function to remove the time.

DateTimeFormat(DateTimeParse([Field1], "%A, %B %d, %Y %I:%M %p"),"%Y-%m-%d")

 

Cheers,

Asteroid

@Thableaus - I modified @CharlieS solution also to skip time.

 

DateTimeParse([Date of query receive],"%A, %B %d, %Y")

 

Labels