Alteryx Designer Desktop Discussions

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

Need to add in a column with end date/week

MatthewCain
5 - Atom

Hello,

 

I'm working on a project and we have no way to incorporate the latest week end date into the export. I need to add an end date column that always ends on the most recent Saturday, is this possible in Alteryx?

 

Thanks in advanced

1 REPLY 1
binuacs
21 - Polaris

@MatthewCain  One way of doing this is based on the current date. If you want to create the most recent Saturday date based on any particular date replace that date with the DateTimeToday() function

image.png

Labels
Top Solution Authors