Need to add in a column with end date/week
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MatthewCain
5 - Atom
‎02-21-2024
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Date Time
1 REPLY 1
binuacs
21 - Polaris
‎02-21-2024
09:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)