How to change dates into strings (skip weekoffs)

Question

Hi All,

could someone help me on the below issue. i want to change specific column date to String like T0,T1,T2 .

by skipping weekend day (Saturday and Sunday)

Input       30/06/202303/07/202304/07/202305/07/202306/07/202307/07/202310/07/202311/07/2023                Output       T0T1T205/07/202306/07/202307/07/202310/07/202311/07/2023

Anjankumar2021 · Answer

i mean next working days dates : 03/07/2023 and 04/07/2023 - want to convert in to T1 and T2

Anjankumar2021 · Answer

weekoffs dates ( 01/07/2023 and 02/07/2023) already skipped or not in input data but want to convert next date to working date 03/07/2023 to T1 and 04/07/2023 to T2. pls help advise on T1 and T2

if we use if condition with

"IF Contains([_CurrentField_],DateTimeToday())
THEN "T0"
ELSE [_CurrentField_]
ENDIF"

i can easily convert todays date 30/06/2023 to T0 ( no issue with this)

Nezrin · Answer

Create a field with sequence(1,2,3) and append with T.

Then use the formula tool to (i) convert to DateTimeFormat (ii) get the day of week using below

DateTimeFormat([DateField],"%A")

(ii) use if statement to skip weekends and replace