Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Change Date format to DD/MM/YYYY

Posted on by 920

HI,

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

thanks.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Change Date format to DD/MM/YYYY

    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

  • axk Profile Picture
    axk 925 on at
    RE: Change Date format to DD/MM/YYYY

    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.

  • veeru ogu Profile Picture
    veeru ogu 3,851 on at
    RE: Change Date format to DD/MM/YYYY

    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

  • BASMA Profile Picture
    BASMA 920 on at
    RE: Change Date format to DD/MM/YYYY

    its a customization.how can i do it with code

  • axk Profile Picture
    axk 925 on at
    RE: Change Date format to DD/MM/YYYY

    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
    BASMA 920 on at
    RE: Change Date format to DD/MM/YYYY

    hi veeru,

    i want to change in salesinvoice report

  • BASMA Profile Picture
    BASMA 920 on at
    RE: Change Date format to DD/MM/YYYY

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

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: Change Date format to DD/MM/YYYY

    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.

  • Suggested answer
    axk Profile Picture
    axk 925 on at
    RE: Change Date format to DD/MM/YYYY

    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.

  • veeru ogu Profile Picture
    veeru ogu 3,851 on at
    RE: Change Date format to DD/MM/YYYY

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans