Date Conversions

[Siddharthag]

Spoiler

Spoiler

Spoiler

Hi Folks

I have date field in my data set which is not in proper format from 1 to 12 of every month it's reading as yyyy-mm-dd and from 13th of the month it's taking as mm/dd/yyyy.

I already tried few thing from previous discussions but nothing worked as such. Please help me out.

Thanks in Advance.

Sincerely,

Siddhartha

[ponraj · Accepted solution]

Just see if the attached workflow helps you..

[Siddharthag]

It's helping but I have 20,000 records and which is reduced to 6 records

[LordNeilLord]

Hey @Siddharthag

Try this,

If you add a formula tool with the formula: DateTimeParse([Order Date],"%m/%d/%Y") this will convert your dates after the 13th. All of the other dates will be null. You can then split the data using the nulls and join them back together for a final dataset.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[Siddharthag]

My date field has two different formats yyyy-dd-mm but alteryx defaultly taking as yyyy-mm-dd till 12th of every month from 13th to 30th it's taking as mm/dd/yyyy. When imported it's v_string data type. Data is not in Table format in excel file. It's semi-structured.

[Siddharthag]

Here are some of the errors