Change Date Format

missdeeh

Hello!
I am European but work in Canada. Can anyone tell me how to change the date format?

It is set 18/2/2007 and I need 2/18/2007.

I work with Navision Attain 3.6

Thank you!

monteiro

Hi missdeeh,

Try: FORMAT(your date,0,'<Month,2>/<Day,2>/<Year4>')


Best regards,

Monteiro

Malajlo

Change your regional settings, number/date/time formats.
Afterall, it doesn't matter, how you see formats. Important is that your customers see correct format.