Date format

[Pomna]

Please I need help formatting date in the load script.

My date reads 5-Jan-2016

but I need it to be 01/05/2016

Thanks.

[sunny_talwar · Accepted solution]

Try this

Date(Date#(DateFieldName, 'D-MMM-YYYY'), 'MM/DD/YYYY') as DateFieldName

[Pomna]

Thank you. It worked!