Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Formula to Combine Weekend Dates with Monday

BrandonS4
8 - Asteroid
‎07-01-2020 10:40 AM

Is it possible to add weekend dates together with a Monday date?  I am trying to combine sales for Saturday and Sunday to sales for Monday.  For example,

 

Saturday, July 4, 2020 + Sunday, July 5, 2020 + Monday, July 6, 2020 would equal Monday, July 6, 2020.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor
‎07-01-2020 11:16 AM

Hi @BrandonS4 I mocked up a workflow let me know what you think. From your question I assumed the date format was "Saturday, July 4, 2020" please let me know if that is not the case?

Dates_01072020.yxmd
Reply
0 Likes
BrandonS4
8 - Asteroid
‎07-27-2020 10:46 AM

This still works great.  However, how can I write the formula so the output is two digit month-two digit day-4 digit year??

Reply
0 Likes
vaishnavic
5 - Atom
‎11-11-2022 12:06 AM

If DateTimeFormat(DateTimeParse([Date],"%d-%m-%Y"),"%A") ="Sunday" then
DateTimeAdd(DateTimeParse([Date],"%d-%m-%Y"),1,"day") Elseif DateTimeFormat(DateTimeParse([Date],"%d-%m-%Y"),"%A") ="Saturday" Then DateTimeAdd(DateTimeParse([Date],"%d-%m-%Y"),2,"day") Else DateTimeParse([Date],"%d-%m-%Y") Endif

Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All