Change the date format for documents printed within NAV2016

Eoin_L

Currently my date format within sales invoices prints as '3. December 2016' - I want to show this as 3/12/15 instead. How do I change the date format for date fields printed on Sales Documents such as posted sales Invoices? ie display 'duedate' as dd/mm/yy instead of '3. December 2016' . Many Thanks.

Arhontis

I think that you can place the following in the expression of a textbox (this is an example):

=Format(Fields!PostingDate_SalesInvoiceHeader.Value, "dd/MM/yyyy")

Source:
http://stackoverflow.com/questions/15975955/how-do-i-format-date-and-time-on-ssrs-report
http://stackoverflow.com/questions/28490531/ssrs-format-date-from-yyyymmdd-to-mm-dd-yyyy

Eoin_L

Thanks, I found the answer here - https://msdn.microsoft.com/en-gb/dd301174(v=nav.90).aspx

mdPartnerNL

link is not working?

Eoin_L

"https://msdn.microsoft.com/en-gb/dd301174(v=nav.90).aspx"