Link to home
Start Free TrialLog in
Avatar of mahmood66
mahmood66Flag for United Arab Emirates

asked on

How to change Date format in every reports in AX 2012

I have changed my system format date to dd-MM-yyyy. But all of the date in reports are still shown in mm/dd/yyyy. Is there anyway to change this and affect every reports in AX 2012?

How to make (dd-mm-yyyy) as default format in every reports in AX 2012

Thank you!
Avatar of Damon Repton
Damon Repton
Flag of United Kingdom of Great Britain and Northern Ireland image

hello

this can depend on this type of report but the date format come off the region setting on:

Customer/Vendor
User
and Company

from within AX itself
of you really want to force the format you can do this.

First choose the date field that you want to use in the layout and select text box properties.

 User generated image
Select the number tab, choose customer and enter the format you wish to use. This example forces the American date format.

 User generated image
Avatar of mahmood66

ASKER

Dear Damon Repton,
         very sorry for late reply, i was on my vaccation,
thru report i know, how to change, but you know we have 100s of reports in AX, i cannot change each and every field in each report. it will be very big job.  so i want to know, is there any way, all report start showing the date format like dd-MMM-yy (e.g. 01-Nov-15).
waiting . . . for reply.
ASKER CERTIFIED SOLUTION
Avatar of Damon Repton
Damon Repton
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial