Date format in AX2009

Finance and Operations/AX User Forum
1

Hi,

In Ax2009 existing date format is mm/dd/yyyy . We want this to be dd/mm/yyyy.

Any suggestions to change it in all our applications.

Regards

2

It uses user’s date format from Windows (Control Panel > Region and Language or something like that).

3

Try changing your system regional settings.

4

Hi,

You can also change it By using the data method and declare the field as string and use the

function str2date(Passing the parameter as per enum type selection).

Thanks

5

Thanks for the suggestion.

6

Hi,

you can use the following code for changing the format of date in ax

dt=today();

datestr(dt,123,2,4,2,4,2);

here

dt is todaysdate,

“123” means,1 for day,2 for month,3 for year,u can also reorder these

“2” for printing the day or month or year as per u r chosen format

“4” for seperator like /,-, etc whatever u want

“2” for month

“4” for seperator

"2 "for year

fas per u r requirement u can use above code

check this

Regards

Dhinu.v

7

Hello,

Check the extended datatype that extends your date, probably transdate datatype and change the date format properties to force to the dd/mm/yyyy format you want.

Regards,

Thomas

8

Hi Dhinu,

Thanx for the nice explanation