how ta change date format from DD MM YY to MM DD YY

[#1]

can anyone help me

[#2 · Accepted solution]

Hi,

If the date is a number:

Date(FieldDate, 'MM DD YY')

If the date is a string:

Date(Date#(FieldDate, 'DD MM YY'), 'MM DD YY')

Regards,

Ricardo