date

maniram23 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: date

sunny_talwar — Wed, 24 Aug 2016 10:58:05 GMT

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