Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me to convert the below Date field into DD/MM/YYYY format it contains the MM/DD/YYYY and number format records like below.
Thanks in advance
May be try this
Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date
try like this
Date(Datte_field,DD/MM/YYYY) as date
May be try this
Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date