Required previous date from current date

Question

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 haveDate I want02/06/202231/05/202203/06/202201/06/202204/06/202202/06/202205/06/202203/06/202206/06/202204/06/202207/06/202205/06/202208/06/202206/06/202209/06/202207/06/2022

Regards,

Mahesh

Amol_Telore · Accepted Answer

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.