Date to Day Conversions

[DCB1983]

I have rows and rows of information with 3 years worth of data.

I have the Date as YYYY-MM-DD and using this, I want to determin what day of the week they fall on (Mon, Tue, Wed. etc....)

Any advice ?

[LordNeilLord · Accepted solution]

Hey @DCB1983 

DateTimeFormat(Date, "%A") or DateTimeFormat(Date, "%a")

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

[Thableaus · Accepted solution]

Hi @DCB1983 

Use DateTimeFormat function in Formula Tool.

DateTimeFormat([Field1],"%A")