Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Change Date Format in ...
Small and medium business | Business Central, N...
Suggested answer

Change Date Format in Word Reports

(1) ShareShare
ReportReport
Posted on by Jared M 42
Hello,
 
I have a custom report layout for a word report and I'm wanting to change the format of a date field. I'm on the Sales-Shipment report, but any report will do. The word file has fields that look like this:
 
 
When I run the report, it looks like this, dynamically updating the date and order no.'s accordingly:
 
 
However, I want to change the /September 22, 2023/ format to be /9/22/2023/ and can't figure out how. Surely Microsoft would enable a simple way to do this, but so far all my searching and asking has come up empty. Some solutions exist that require a developer and AL, but something as simple as a date format should be easily accessible to a common user. I've seen a few other posts similar to this and none of those solutions work (maybe they used to, but not anymore). A few examples of solutions that do NOT work now:
 
 
Any solution that works and only requires Word would be greatly appreciated!

Thanks,
 
Jared
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,312 Super User 2025 Season 1 on at
    Change Date Format in Word Reports
    Hi,
     
    Using report extension, you can add date field in your report dataset with the formatting as per your requirement.
    Once field added in dataset you can use it in word layout.
     
    Regards,
    Saurav Dhyani
  • CU03060138-1 Profile Picture
    CU03060138-1 4 on at
    Change Date Format in Word Reports
    I'm not seeing where you can alter the format of your dates if you're searching for a non-developer answer. You have the option to update the area.  
     
     
  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,211 Moderator on at
    Change Date Format in Word Reports
    Hi Jared M,
    If you are looking for a solution that does not require development, then I don't see the place where you can change your date format. What you can do is update the region. For example, if you update your region in BC settings, your date format will also be updated...
    Regards
  • Jared M Profile Picture
    Jared M 42 on at
    Change Date Format in Word Reports
    @ZHU  Thank you for your response, but I'm looking for a solution that does not require a developer or coding in AL. Is there a place I can do this within BC or within the Word report, without having to learn AL?
     
    If so, how do I modify the Format Region? In the link you provided, I see that it would be "<Closing><Month,2>/<Day,2>/<Year>" but I'm not sure where I would make this adjustment. Where is the Format Region within BC?
     
    Thanks,
     
    Jared
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 78,733 Super User 2025 Season 1 on at
    Change Date Format in Word Reports
    Hi, I think you can try the following two ways.
    1. Try to modify the Format Region of the report
     
    2. Don't display it in date format, format it as text in your code first.
     
     
    Hope this helps.
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans