How to get DATE of tomorrow and day after tomorrow

[Anjankumar2021]

[ShankerV · Accepted solution]

Hi @Anjankumar2021 

One way of doing this.

The date will be dynamic based on the date you are running the workflow.

Use the below formula to ger the output as 25/02/2023

IF [_CurrentField_]="T1"
THEN datetimeformat(datetimeadd(datetimetoday(),1,"days"),"%d/%m/%Y")
ELSEIF [_CurrentField_]="T2"
THEN datetimeformat(datetimeadd(datetimetoday(),2,"days"),"%d/%m/%Y")
ELSE [_CurrentField_]
ENDIF

Many thanks

Shanker V

[binu_acs · Accepted solution]

@Anjankumar2021 One way of doing this

[Raj]

use formula tool

for Tomorrow -  DateTimeAdd(DateTimeToday(),1,"Days")

and for Day after tommorow -  DateTimeAdd(DateTimeToday(),2,"Days")

this will help

[binu_acs]

@Raj @Anjankumar2021 requirement was to update the column heading, dynamic rename tool is the best option, else the data should be transposed then make the changes using the formula tool then cross tab the result

[Anjankumar2021]

can we skip weekends (saturday and Sunday) and get Monday (27/02/2023) as T1, Tuesday (28/02/2023) as T2. pls assist

[Raj]

@binu_acs Thanks for sharing I took the long path 😅

[binu_acs]

@Anjankumar2021 One way of doing this is by transposing the data. The same formula can be applied in the dynamic rename tool as well but it till make more confusing to you, so I thought of choosing a different way which was explaining to @Raj 😀

[binu_acs]

@Anjankumar2021 If in case you want all done by dynamic tool you can go for the below solution