DATE CONVERSION ISSUE

[annamalaimoorthy]

Hi Beloved community, 

I am facing a probolem in converting the Date format of a field. 

Source : Oracle DB

Input date format :  2020-11-23  Date type : Datetime

I need to convert this as below

Expected output :  23-NOV-20   Date type : Datetime

I have tried using TODATE, DATEPARSE and DATETIMEFORMAT. 

None of which return desirable results. 

I have tried the formula DATETIMEFORMAT([orderdate], "%d-%b-%y") but the output comes as NULL when I set the data tyoe as DateTime ,

It returns the expected value as a string. 

Then I tried the below and set the data type as datetime

TODATE(DATETIMEFORMAT([orderdate], "%d-%b-%y") ) 

This is returning NULL values. Guess I am missing something small, but not sure what. Any help would be highly appreciated. 

Thanks

Annamalai Moorthy

Standard Chartered Bank

[Qiu]

@annamalaimoorthy 

We need to have a new field for the converted Date Format.

Then use a Select to replace the original Field.

I guess Alteryx is not allowing updating the field self in this case.

[grazitti_sapna · Accepted solution]

Hi @annamalaimoorthy,

DD-Mon-YY is not the datetime format that Alteryx accepts. Although you can convert your date fields to this format as shown by @Qiu  in his workflow, but the output would be a String field and not the Date field as you want.