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
use formula tool
for Tomorrow - DateTimeAdd(DateTimeToday(),1,"Days")
and for Day after tommorow - DateTimeAdd(DateTimeToday(),2,"Days")
this will help
@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
can we skip weekends (saturday and Sunday) and get Monday (27/02/2023) as T1, Tuesday (28/02/2023) as T2. pls assist
@binuacs Thanks for sharing I took the long path 😅
@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 😀