Issue with Date Formatting

[Anonymous]

Hello Everyone,

I am having DOB from excel and formatting it like this:

date(Date#(DOB,'DD/MMM/YYYY')) as Test,

After running it I am getting Test as a blank field..any suggestion?

Regards,

Balraj Ahlawat

[Anonymous]

Done

[#3]

Try This

Date(Date#(DOB,'ddMMMyy'),'dd-MMM-yy') as Test