Small and medium business | Business Central, N...

Date Format in PO template

(0) Share

Report

Posted on by MY-09081605-0

We have a word template for our POs. This pulls the field "Expected Receipt Date" from the purchased lines. The date comes through in the format "14 September 2021" - see below. Is there a way to format the date so it displays "14/09/21" instead? Does this need to be done in the Word template or in BC?

0020.Capture.JPG

All responses (4)

Answers (0)

Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: Date Format in PO template

Seems like formatting on BC side in report code is the only way. the problem is not new:

community.dynamics.com/.../date-format-in-custom-report-layout

community.dynamics.com/.../changing-date-format-to-be-displayed-in-report

www.google.com/search
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Date Format in PO template

Hello,

Have a look here:

docs.microsoft.com/.../ui-enter-date-ranges

Thanks.
MY-09081605-0 35 on at

Like (0)

Report

RE: Date Format in PO template

Are you sure that is correct?... As in BC the date is displayed as "14.09.21" not "14 September 2021"

This is a snip from BC...
Suggested answer

JAngle 83 on at

Like (0)

Report

RE: Date Format in PO template

In BC. The layout just presents the data that BC prepares for it. A report extension could be used. Add your own date field and use the format() function. Something like column(Newdate;format(“Expected Receipt Date”,0,4)) {} should do the trick