Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

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

Required previous date from current date

Maheshp
8 - Asteroid

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
8 - Asteroid

Thanks Telore! Now it is working.

Labels