General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Required previous date from current date

Maheshp
7 - Meteor

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 want
02/06/202231/05/2022
03/06/202201/06/2022
04/06/202202/06/2022
05/06/202203/06/2022
06/06/202204/06/2022
07/06/202205/06/2022
08/06/202206/06/2022
09/06/202207/06/2022

 

Regards,

Mahesh

 

2 REPLIES 2
Amol_Telore
11 - Bolide

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.

 

Amol_Telore_0-1660110580133.png

 

Maheshp
7 - Meteor

Thanks Telore! Now it is working.

Labels