Alteryx Designer Desktop Discussions

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

3 weeks prior to date

wonka1234
10 - Fireball

Hi,

 

Lets say I have a date like this - 2023-03-13

 

How can I get a date 3 weeks prior ? or 21 days? in a Date format in a new column?

1 REPLY 1
binuacs
21 - Polaris

@wonka1234 Use the DateTimeAdd() function 

 

DateTimeAdd([Date],-21,'days')

Labels
Top Solution Authors