News and Announcements icon

Dynamics 365 CommunityForums Business Central forum How can I use Formatti...

Business Central forum

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:

Opportunity Management

Reports and Business Intelligence

Inventory and warehouse management

All responses Img

All responses (3)

Answers Img

Answers (1)

JAngle 33,141 on at

Like (0)

Report

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

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

YUN ZHU 68,536 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Suggested answer

Stefano Demiliani 37,160 on at

Like (0)

Report

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

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

Date2DMY()

DT2Date()

DT2Time()

DMY2Date()

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2

Martin Dráb 228,135 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans