How to change dates into strings (skip weekoffs)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/2023 | 03/07/2023 | 04/07/2023 | 05/07/2023 | 06/07/2023 | 07/07/2023 | 10/07/2023 | 11/07/2023 |
Output | |||||||
T0 | T1 | T2 | 05/07/2023 | 06/07/2023 | 07/07/2023 | 10/07/2023 | 11/07/2023 |
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Anjankumar2021
What is the logic for conversion date to Tx?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
day wise sales volume. those dates are column names, after conversation will apply filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
day wise sales volume. those dates are column names, after conversation will apply filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Nez
Alteryx ACE | Sydney Alteryx User Group Lead | Sydney SparkED Contributor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i mean next working days dates : 03/07/2023 and 04/07/2023 - want to convert in to T1 and T2