Alteryx Designer Desktop Discussions

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

Generate two weeks from current date but should always ends on friday

Ultralightbeam
8 - Asteroid

If the date is January 18 2021 it should generate two weeks of dates from January 18 2021 to January 29 2021 and if it is January 29 2021 it still should generate the previous week of January 18 2021 to January 29 2021. it's like rounding off to the nearest friday every two weeks of time.

 

Initially it should generate a rows from January 18 to 29 (always monday to friday next week ) and whatever the current date is it should always fall  to 18 to 29 as long as it's within its range

 

With current date today 26th of January, it should generate from the monday of the 26th of january which is 25 up to the next friday 5th of February.

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Ultralightbeam 

Maybe I understand

Capture12.PNG

Labels
Top Solution Authors