Designer Date Format in column

Hi,

I have an issue with a column which has different formats in the same column which I am struggling with, so I would appreciate any help on the community.

I am struggling to have these dates to be read in Alteryx, attached a sample. Cells (a2:a6) formatted as 'general'; cells (a7:a13) formatted as 'date', then in cell A13, the year appears as '89'

I need the dates to appear as dd-mm-yyyy

So I used the following:

Date1

DateTimeParse([Date],'%d-%m'-%Y') - so I changing the string into date; then I do the following

DateTimeFormat([Date1],'%d-%m'-%Y')

The above formula works well for the dates which are formatted in general but the other items appear as Null, so I am struggling on this one.

Regards,

Dan

Data demo alteryx.xlsx

Developer

Accepted answers

philipmannering

@DanielCarro That's great! Then could you mark this as solved please?

All comments

philipmannering

Hey @DanielCarro

How about using the following,

if REGEX_Match(Date, '\d{4}-\d{2}-\d{2}')
then DateTimeFormat(Date, '%d-%m-%Y')
else Date endif

mixed-date-formats.yxzp

DanielCarro

@Philip thank you very much it did work

philipmannering

@DanielCarro That's great! Then could you mark this as solved please?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703