Convert date from "MM/DD/YYYY HH:MM AM/PM" format to only "MM/DD/YYYY"

[adeyang]

I have date field "11/5/2019 9:00 AM" which I want to remove the time portion to only have "11/5/2019". What can I do?

It is currently in V_Wstring format.

Thanks so much for your help!

[JosephSerpis · Accepted solution]

Hi @adeyang if you just want to remove the time portion use a left function. Alteryx will only recognize YYYY-MM-DD as a true date format I mocked up a workflow which shows how to remove the time portion and convert your date into a format alteryx will reconize as a time format as well. 

[grazitti_sapna · Accepted solution]

Hi @adeyang , You can try this.

Formula: Datetimeformat(DateTimeParse([Date],"%m/%d/%y %I:%M %p"),"%m/%d/%Y")

In case you have different date format and want to omit time you can do this.

Formula: left([date],9)

Thanks.

[adeyang]

Thank you both, it works! 🙂