Announcements
Hi All,
Currently we get US date format in BC. Is there a way to change it to DD/MM/YYYY format?
Just to clarify this is for printed documents ..Currently I have to customize
This will help: docs.microsoft.com/.../format-property
Basic google told me standard format for down under is year-MM-dd so from that list of “standard formats” number 9 looks like the one. So you could do format(“Posting Date”,0,9)
Example shown here: docs.microsoft.com/.../format-function--code--text-
I was more interested in a systemwide setting instead of doing this through code but we can live with it :)
Hi,
Did you try checking the regional settings in your BC settings? Not sure if this will take effect in the documents but usually the issue for date and value separators system wide in BC.
Quick example with the work date - English US:
English Australia:
Hope that helps
Regards,
Martin
Thanks but this doesn't affect documents. Hopefully future version will have localization based date formats in RDLC
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,042 Super User 2026 Season 1
Dhiren Nagar 1,077 Super User 2026 Season 1
YUN ZHU 1,068 Super User 2026 Season 1