web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How can I use Formatti...

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

Answered

How can I use Formatting Values, Dates, and Time in Business Central? (Example)

(0) Share

Report

Report

Posted on by Sujan Khadka

80

I saw the documentation of fomatting values, dates and time is business central. But couldn't understand it. Is there sample example to this?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Question is not cleat but to format date you have different possibilities. I suggest to check for the following functions:

Date2DMY()

DT2Date()

DT2Time()

DMY2Date()

Was this reply helpful? Yes No
Verified answer

YUN ZHU 97,528 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I am sure you have read the link below.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-property

Just some example, hope helps.

Date:

DateTime:

Boolean

Hope these can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

How adaptable is the first one? As in can you just have the expression text for month and year?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,117 Super User 2026 Season 1

#2

YUN ZHU 1,092 Super User 2026 Season 1

#3

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans