Need a help in date formatt

[SatyaPaleti]

Hi Friend,

I am having date in following format '01-DEC-2015' but i want to show this in 12/01/2015

what is the function i need to use here

Thank you,

Satya Paleti

[sunny_talwar]

Try this:

Date(Date#('01-DEC-2015', 'DD-MMM-YYYY'), 'MM/DD/YYYY')

Replace 01-DEC-2015 with your field name to do this in the script

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

[SatyaPaleti]

Thank you so much Sunny It Works