Date Format

Hi,

I am using Nav 2009 and it is a Canadian version although I work in the UK.

Our documents show a date as MM DD YYYY which is fine for us but confusing for our suppliers etc.

When we print a sales invoice it shows as 12th February 2016.

How can I get this full date format to show on PO’s, sales quotes etc.

Thanks for your help in advance

You’ll need to format the date before assigning the value to a report field.

Something like this:

DateText := FORMAT(Date, 0, ’ ');

More on formatting variables into strings on msdn:

https://msdn.microsoft.com/en-us/library/dd301367.aspx

https://msdn.microsoft.com/en-us/library/dd301059.aspx