Notifications
Announcements
No record found.
HI,
i want to change the format of date from mm/dd/yyyy to dd/mm/yyyy.
thanks.
*This post is locked for comments
May i know where you want to change the date format?
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.
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.
but only in one report i see date like this mm/yy/dddd
hi veeru,
i want to change in salesinvoice report
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).
its a customization.how can i do it with code
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
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.
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.
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
