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 :
Microsoft Dynamics AX (Archived)

Change Date format to DD/MM/YYYY

(0) ShareShare
ReportReport
Posted on by 932

HI,

i want to change the format of date from mm/dd/yyyy  to dd/mm/yyyy.

thanks.

*This post is locked for comments

I have the same question (0)
  • veeru ogu Profile Picture
    3,851 on at

    May i know where you want to change the date format?

  • Suggested answer
    axk Profile Picture
    925 on at

    Hey,

    Date format in AX is based on your Windows setup as far as I know. If you change it in your OS, it will affect AX.

  • Guy Terry Profile Picture
    28,944 Moderator on at

    The date format you see in AX is taken from the regional settings of the user's Windows log-in. If your Windows user has a Date format of dd/mm/yyyy then that's what you'll see in AX.

  • BASMA Profile Picture
    932 on at

    but only in one report i see date like this mm/yy/dddd

  • BASMA Profile Picture
    932 on at

    hi veeru,

    i want to change in salesinvoice report

  • axk Profile Picture
    925 on at

    Is it AX2012 standard report or some customization? If it's cutomized to display date as a string, it's probably set in date2str method, where you can pass date sequence (for example 321 for YYYYMMDD).

  • BASMA Profile Picture
    932 on at

    its a customization.how can i do it with code

  • veeru ogu Profile Picture
    3,851 on at

    Hi ,

    In 2 ways you can change the date format

    1) In report design level you can change the format of control

    2) you can change the  EDT level

  • axk Profile Picture
    925 on at

    If that's customization, it's going be difficult to find it for you.

    You should probably search in SalesInvoiceDP class. That's where the data is provided to report.

  • Verified answer
    Community Member Profile Picture
    on at

    Hi,

    you can go to the visual studio and open the design of your report, and in the text box properties of date text box you can find "Number" on the left side, under "Category" select Date and finally under Type select your required date format. Also you can set the format from the Custom category.qry-answer.jpg

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans