Convert Date to Weekday

[tessaenns]

Hello,

I have a column field labeled "date" and I need an additional column field that can translate the date to the corresponding day of the week.

Example:

Date                              Weekday

2/18/2019        ----->      Monday

I have the Date field, but need to populate the Weekday field, does anyone know how to do this? Thank you!

[DavidP · Accepted solution]

Try DateTimeformat(DateTimeParse([Date],'%m/%d/%Y'),'%A')

[estherb47 · Accepted solution]

Hi @tessaenns !

Try this formula out: 

DateTimeFormat([Date],"%A") 

Your date field needs to be in Date format for the above to work. If it isn't, use the DateTimeParse function first, or the DateTime Parse tool.

Cheers!!

Esther

[DavidP]

You can find information on Alteryx DateTime functions and formats here:

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

[tessaenns]

Thank you David, this worked beautifully! When the data type is set as V_String, the formula worked like a charm!

[JITHINPR]

My Solution

[Sambit_198]

Simplest option I can think of is below. Then use Text to columns to split using Comma (,) as delimiter