Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Day of week as number

Pascal_R
8 - Asteroid

Hi Team,

 

Is there a way to get the number of a weekday out of a date?

Currently my data set is like below type: V_string. 

 

I want to have a new column next to this Ac.GI date which say like:

 

"5" for the 12.11.2021 (Friday) etc...

 

Pascal_R_0-1636970261728.png

 

 

8 REPLIES 8
Christina_H
14 - Magnetar

DateTimeFormat([Ac.GI date],'%w')

 

Goes from Sunday = 0 to Saturday = 6

JulioMO
9 - Comet

Attached you will find a solution. 

 

Best regards

Pascal_R
8 - Asteroid

Hi @Christina_H 

 

If I just add the formula I only have nulls. Can you please check attached file and let me know if I need to chance any format or so?

 

BR,

Pascal

afv2688
16 - Nebula
16 - Nebula

Hello @Pascal_R ,

 

Just one little thing to add here would be if you want to be sunday the seventh day insted of the first would be to add a replace to the formula too.

 

Replace(DateTimeFormat([Field1],'%w'),'0','7')

 

Regards

afv2688
16 - Nebula
16 - Nebula

Hello @Pascal_R ,

 

You need first to transform the dates to actual dates that Alteryx can understand. As the stand on your file they are interpreted just as text. Try using this

 

Replace(DateTimeFormat(DateTimeParse([Ac.GI date],'%d.%m.%y'),'%w'),'0','7')

 

Regards

Christina_H
14 - Magnetar

@Pascal_R

 

As @afv2688 says, you need to convert your date to a date format in Alteryx first.

ATP_1973
5 - Atom

Is there a way to have it where Sunday is 1, Monday 2, etc.?

AndrewDMerrill
13 - Pulsar

@ATP_1973 

Use ToNumber(DateTimeFormat([Date], "%w"))+1

Labels