Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Formatting date on report

Posted on by 203
Hello.
My reports by default print the dates as 11. January 2024
I want the format of the dates to be 11.01.2024.
This includes all the default date fields especially in the Sales Invoice, Purchase Order, and Sales Order report, but I would like this to be the default for all reports. 
How can I achieve this?
Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,539 Super User 2024 Season 2 on at
    Formatting date on report
    Hi, as standard this is based on country and region settings, you can try to change the settings below.
     
    As for what Shrey mentioned, this is for developers and needs to be defined in code.
     
    Hope this helps.
    Thanks.
    ZHU
  • Hagru Profile Picture
    Hagru 203 on at
    Formatting date on report
    Where would I add that code in case?
    I do have reportextensions for the tables I mentioned, but I am not sure where to add those lines in case.
    Also, is there a way to set this as the default for every report, so that I don't have to make x amount of report extensions?
  • Suggested answer
    Shrey Chauhan Profile Picture
    Shrey Chauhan 288 on at
    Formatting date on report
    Hello,

    You can use this following code to get this 11.01.2024 date format in report  :

    1. Rec.Date := format(Rec.Date, 0, '<Day,2>/<Month,2>/<Year4>');
    2. Rec.Date :=Format(Rec.Date,40, '<Standard Format,1>')
    Hope this help to solve your problem.
    May other expert's give you better solution.

    Thank you, 
    Shrey Chauhan

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,137 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans