DATE CONVERSION ISSUE

Question

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

Datetime error.yxmd

grazitti_sapna · Accepted Answer

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.