date

[maniram23]

Hi experts,

I have data format like "DD/MM/YYYY, MM/DD/YYYY,DD-MM-YYY, DD/MMM/YYYY"

in a date filed.

But i want all data of date field format is like "DD-MMM-YYYY".

Please give one example with practically.

[sunny_talwar · Accepted solution]

Try this:

Date(Alt(

          Num(DateField),

          Num(Date#(DateField, 'DD/MM/YYYY')),

          Num(Date#(DateField, 'MM/DD/YYYY')),

          Num(Date#(DateField, 'DD-MM-YYYY')),

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