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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MY-09081605-0 37 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Have a look here:

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

Thanks.

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

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

Was this reply helpful? Yes No