[Liz McQuiston]

I’m working on creating some custom layouts in word and wondered if anyone knows how to change the date format?  When I select certain date fields it puts the date and time in, for example…

{ShptDate_SalesHeader} prints 3/28/2019 12:00:00 AM all I want is 3/28/2019

——————————
Liz McQuiston
Corporate Controller
Superior Walls of America
New Holland PA
Running NAV 2016
——————————

[Matt Traxinger]

I don’t think you can do this in the Word layout, you have to do it from the data set. You could do it in RDLC.

If you go design that report (Development Environment –> Tools –> Object Designer –> Find the Report and click Design) that will bring up the data set. You can find the one that matches your Sales Header Shipment Date and change the “Data Source” column. Instead of “Shipment Date” it should be something like

FORMAT(“Shipment Date”, 0, 0)

That last 0 represents one of the formats found here.

If you wanted it exactly like you have it would be something like

FORMAT(“Shipment Date”, 0, ‘<Month,2>/<Day,2>/<Year4>’)

Hope that helps.

——————————
Matt Traxinger
NAV Developer
ArcherPoint Inc.
San Antonio TX
——————————
——————————————-

[Liz McQuiston]

Matt that worked perfectly, thanks so much!

——————————
Liz McQuiston
Corporate Controller
Superior Walls of America
New Holland PA
Running NAV 2016
——————————
——————————————-

[Susan Lewis]

Matt,  I’m on 2018 with Events and Extensions. 
Can I follow the same steps to format my report dates?
Thanks!

——————————
Susan Lewis
American Art Clay Co
Indianapolis IN
——————————
——————————————-

[Matt Traxinger]

It depends on whether you are using the AL language (new programming language for NAV / BC) to do those extensions.

If you are using C/AL (the old language) then yes you can. It’s always advisable to create a copy of the report and make all of your changes there, though. That way you avoid making a base object change.

——————————
Matt Traxinger
NAV Developer
ArcherPoint Inc.
San Antonio TX
——————————
——————————————-

[Susan Lewis]

Thank you Matt!

That’s what I thought but wanted to verify.  We are using the AL language. 

 

Susan Lewis

 

——Original Message——

It depends on whether you are using the AL language (new programming language for NAV / BC) to do those extensions.

If you are using C/AL (the old language) then yes you can. It’s always advisable to create a copy of the report and make all of your changes there, though. That way you avoid making a base object change.

——————————
Matt Traxinger
NAV Developer
ArcherPoint Inc.
San Antonio TX
——————————