web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to change date for...

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

Suggested Answer

How to change date format in custom report in Business Central

(0) Share

Report

Report

Posted on by Amit Bansal

55

Hi,

I want to change current "shipment Date" to "01-Dec-2022".

Thanks,

Amit

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Amit Bansal 55 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In addition to previous, I want to change current "shipment Date" from 01/12/22 to "01-Dec-2022".

Thanks,

Amit

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,409 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

look documentaion

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

DAniele

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,409 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

use this

FORMAT(YOUR_DATE,0,'<Day,2>-<Month Text,3>-<Year4>')

Was this reply helpful? Yes No
Amit Bansal 55 on at

Like (0)

Report
Copy link

Link copied!

Thanks, that works.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,682 Super User 2026 Season 1

#2

YUN ZHU 1,010 Super User 2026 Season 1

#3

Kamal Khakhkhar 495

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans