AX2012 R2 Dateformat, DD-MMM-YYYY in French

(0) Share

Report

Posted on by CU14050944-0

we use as dateformate DD-MMM-YYYY. When the dynamcis user is set to EN-US it look good for June / July

12-Jun-2015, 12-Jul-2015

When setting the date format to FR-FR ..

i get 12-Jui-2015, 12-Jui-2015 ( as June = Juin , July = Juillet) .. so the 3 letters "Jui" make from a first 3 letters standpoint sense .. but not for the user to read. MS Windows seems to avoid this problem, when setting to MMM in French you get the full month name ...

Any ideas about that

Pirmin

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Hi Pirmin,

You this job; it will date like July 02, 2015

You can change as per your requirements

static void datesJob(Args _args)

{

str dd, mm, yy, dt;

dt = date2Str(systemDateGet(), 123, DateDay::Digits2, DateSeparator::Slash, DateMonth::Digits2,

DateSeparator::Slash, DateYear::Digits4);

dd = substr(dt, 0, 2);

mm = substr(dt, 4, 2);

yy = substr(dt, 7, 4);

dt = mthname(str2int(mm)) + ' ' + dd + ', ' + yy;

print dt;

pause;

}

Was this reply helpful? Yes No
CU14050944-0 on at

Like (0)

Report

Hi

well we look for a solution of keeping the date format to DD-MMM-YYYY but maybe replacing the JUI for JUIN with JUN ..

thx

Pirmin

Was this reply helpful? Yes No
Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Sorry did not get your point - did this work or not? What problem you are having ?

Was this reply helpful? Yes No
Suggested answer

Douglas Noel 3,905 on at

Like (0)

Report

Hi Pirmin,

I understand your problem. The point is: Ax does use a kerneltext file (ktd) for translating the setting from control panel to the output.

in your case: look at the file AxSysFR.ktd in your client bin folder. search for #99

TC_MONTH

ATTENTION ATTENTION do not change more then the following DIRTY workaroud

change the 3rd and 4th letter within Juiliet to e.g. Julilet (save the file)

restart your client and see. Using this

Keep in mind: This is a dirty workaround. It is not recommended to modify these files. Only experimental.

And also keep in mind: You have to do this on each client.

!!! And do not exchange Janvier and Octobre :-)

regards

Douglas

Was this reply helpful? Yes No