Handling dates

[NitiGupta]

Hi, I am new to Alteryx and I want to populate the Monday of the week for any input date that I have. How can this be achieved in Alteryx?

[RolandSchubert · Accepted solution]

Hi @NitiGupta ,

there are some DateTime functions you can use to do that.

Step 1: Convert your date to a "Date" data type in Alteryx (DateTimeParse)

Step 2: Find the day of week for that date (DateTimeFormat, there is a specifier "%u" returning the day of week with 1 = Monday)

Step 3: subtract the appropriate number of days from your date (DateTimeAdd) and you should be done.

I've attached a sample workflow, let me konw if it works for you.

Best,

Roland

[NitiGupta]

Thanks so much for helping with the right functions. It worked as expected.