Date format issue

[viveksingh]

Hi Experts,
I have date format in different formats for a column in a qvd. Like below
3/30/1999 12:00:00 AM
36531
5/4/1995 12:00:00 AM

How to conver to dd/mm/yyyy

[jonathandienst]

Like this:

Date(Alt(Date#(myDateField, 'M/D/YYYY hh:mm:ss tt'), myDateField)) as DateField,

[jyothish8807 · Accepted solution]

Hi Vivek,

Try like this :

date(Alt(date#(Date,'MM/DD/YYYY hh:mm:ss TT'),
num#(Date,'#####'),
date#(Date,'DD/MM/YYYY hh:mm:ss TT'),
'NA')) as NewFiled

[viveksingh]

Perfect. Thanks.