Hello Experts!
I have 2 queries in regards to altering the date format in alteryx.
1) The dates are currently appearing in format yyyymmdd in field 'Date' (see input column) which needs to be converted to 'Date' (see output column) in format ddmmyyyy. This field is currently reflecting as 'v_string' type. refer to grid 1
2) In 'Start' and 'End' columns, where the value 'nil' exists, no change is required, however for the rest of the values, they need to be converted from yyyymmdd to ddmmyyyy. This field is currently reflecting as 'v_string' type. refer to grid 2
Would appreciate any help with this please.
Thanks
Input | Output |
Date | Date |
20230427 | 2702023 |
20230418 | 18042023 |
20230222 | 22022023 |
20230424 | 24042023 |
Input | Output | |||
Start | End | Start | End | |
20230427 | nil | 20230427 | nil | |
nil | 20230222 | nil | 20230222 | |
20230424 | nil | 20230424 | nil |
Solved! Go to Solution.
I see no difference in In and out in the second case
The output is still in yyyymmdd format
Hi binuacs,
First solution was perfect.
For the second one it did convert the necessary values to ddmmyyyy, however the ask was also to retain the value 'nil' in fields where the term 'nil' exists. Is that possible within the same formula please?
@binuacs spot on. thanks