Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Get specific dates in Alteryx

Yuri24
8 - Asteroid

Hello,

 

I understand datetimetoday() function gives us today's date. However, I need to use specific dates in my workflow, prior week start date, prior week end date and current week's tuesday date.

 

Is this possible?

 

TIA

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Yuri24 
For my 100 accepts this month.

And I assme your week starts on Monday.

Capture-3A.PNG

Tyro_abc
11 - Bolide

Hi

I assumed first day of week is Sunday and last day of week is Saturday. We need to adjust the formula if that is not true.

Please let me know, if its help.

 

Tyro_abc_0-1615871337976.png

 

 

Best Regards

Arundhuti

Labels
Top Solution Authors