Customization of Standard date formats

(0) Share

Report

Posted on by Sujan Khadka

The following table shows the standard Date formats with the regional setting of English (US).

US Date	Format	Example
<Closing><Month,2>/<Day,2>/<Year>	0	04/05/21

here for the value of year it's showing only last two character of 2021 that is 21. But I want date format such that 04/05/2021 so can I customize Standard Date formats like Year4 ? Or if there is any solution to this problem ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Please try this

FORMAT(TODAY,0,'<Day,2>/<Month,2>/<Year4>')

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You can also refer the below link

community.dynamics.com/.../how-to-display-date-in-dd-mm-yyyy

Was this reply helpful? Yes No
Sujan Khadka 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help.

Was this reply helpful? Yes No