Hi All,
Currently we get US date format in BC. Is there a way to change it to DD/MM/YYYY format?
Thanks but this doesn't affect documents. Hopefully future version will have localization based date formats in RDLC
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
I was more interested in a systemwide setting instead of doing this through code but we can live with it :)
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-
Just to clarify this is for printed documents ..Currently I have to customize
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…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,119
Nimsara Jayathilaka. 3,902
Sumit Singh 3,021