We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Remove weekends

KLS
8 - Asteroid
‎04-20-2020 02:08 AM

Hi,

 

Have a scenario where I would like to include previous day. Ive added in the formula as DateTimeAdd([Date],1,"days") =datetimetrim(datetimestart(),"day"). However this day actually falls on a Sunday as Im running them on Monday(today). Is there a way to exclude Sat/Sun and include in last week latest date ie Friday?

 

20th April( today) need to include in 17th April (last Friday).Appreciate the help thank you.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

11 REPLIES 11
KLS
8 - Asteroid
‎04-22-2020 04:56 AM

@RolandSchubert  in times like these your a healer. Fingers crossed it'll be good on Monday, thanks.

Reply
0 Likes
KLS
8 - Asteroid
‎04-27-2020 08:58 AM

@RolandSchubert  it works ,thanks so much

Reply
0 Likes
Labels
Top Solution Authors
View All