Required previous date from current date

[Maheshp]

Hi,

I am going to prepare a workflow but at one point I got stuck where I need previous dates with the help of available date.

Like below:- In first column the dates which I have but in second column where I want, so with the help of formula how can I get this.

Date I have	Date I want
02/06/2022	31/05/2022
03/06/2022	01/06/2022
04/06/2022	02/06/2022
05/06/2022	03/06/2022
06/06/2022	04/06/2022
07/06/2022	05/06/2022
08/06/2022	06/06/2022
09/06/2022	07/06/2022

Regards,

Mahesh

[Amol_Telore · Accepted solution]

Hey @Maheshp 

You can do this by using datetimeadd formula. To get the previous date you need to put negative value in formula. To get upcoming date,put positive value.

Formula : datetimeadd([date i have],-2,'days')

Attached is the solution.

[Maheshp]

Thanks Telore! Now it is working.