web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Date and Currency Format issue

(0) ShareShare
ReportReport
Posted on by 25

One of our client is having the issue the issue of Date and Currency format which is used by AX to be fetched on the reports generated in the system.

Recently they started with their new process in which they will be having their local regional settings in French, but as per the analysis they got to know that the setting done by user in local system regional settings is not getting fetched onto the report .

Say, the date setting done in system as “YYYY/MM/DD” but whenever the report is generated it is fetching the format as “yyyy-mm-dd” which is not the required format for them and they are having multiple legal entities across different regions.

So, how can we get the desired results in a functional way rather opting for technical.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,679 Super User 2026 Season 1 on at

    Hi Sunshita,

    You can check the design of the report if the date format is fixed to the current format. If you don't know how to do this or there is no developer available who can check it for you, you can mention an example of a report (not customized) so we can help you checking the field properties.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sunshita Ganjoo,

    Can you share an example of the different date format results that you get?

    Can you also let us know more about the problem that this causes because you mentioned that you have multiple different legal entities and have problems with this date format?

    Many thanks,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    303,679 Super User 2026 Season 1 on at

    Hi Sunshita,

    Is your question resolved or do you need some help? It would be nice if you can update us on the status.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans