Date format query

[griseldagomes]

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

[Raj]

sol for case one

[binuacs]

@griseldagomes two approaches to achieve your result

[Raj]

I see no difference in In and out in the second case

[griseldagomes]

The output is still in yyyymmdd format 

[griseldagomes]

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 · Accepted solution]

@griseldagomes Updated the workflow

[griseldagomes]

@binuacs spot on. thanks