3 weeks prior to date

[wonka1234]

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?

[binuacs · Accepted solution]

@wonka1234 Use the DateTimeAdd() function 

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