Alteryx designer Discussions

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

Getting Day Of Week (DOW) in number format

Highlighted

Hey guys!

 

I was wondering if there is a Date/Time format flag to get the Day Of Week in format number (Sunday = 0, Monday = 1...), just in case there is a quicker way to get this data without having to create a formula.

Highlighted

Not that I can think of, only way I know is a formula tool:

ToNumber(DateTimeFormat([Date],"%w"))

<Shameless plug>

If you have the Abacus function library installed it makes the expression simpler:

WEEKDAY([Date])

</Shameless plug>

Labels