Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to change dates into strings (skip weekoffs)

Anjankumar2021
8 - Asteroid

 

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
6 REPLIES 6
Qiu
21 - Polaris
21 - Polaris

@Anjankumar2021 
What is the logic for conversion date to Tx?

Anjankumar2021
8 - Asteroid

day wise sales volume. those dates are column names, after conversation will apply filter

 

 

Anjankumar2021
8 - Asteroid

day wise sales volume. those dates are column names, after conversation will apply filter

Nezrin
11 - Bolide
11 - Bolide

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

Thanks,
Nez
Alteryx ACE | Sydney Alteryx User Group Lead | Sydney SparkED Contributor
Anjankumar2021
8 - Asteroid

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)

Anjankumar2021
8 - Asteroid

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

Labels
Top Solution Authors