Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Sign In Register

Categories

Options

Change the date format for documents printed within NAV2016

Eoin_L

Eoin_L Member Posts: 15

2015-12-03 in NAV Three Tier

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.

0

Answers

Options
Arhontis Member Posts: 667

2015-12-04

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

Regards,
Arhontis

https://forum.mibuso.com/search
0
Options
Eoin_L Member Posts: 15

2015-12-04 edited 2015-12-04

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

0
Options
mdPartnerNL Member Posts: 802

2015-12-04

link is not working?

0
Options
Eoin_L Member Posts: 15

2015-12-04 edited 2015-12-04

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

0

Sign In or Register to comment.