Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2012 R2 Dateformat, ...
Microsoft Dynamics AX (Archived)

AX2012 R2 Dateformat, DD-MMM-YYYY in French

(0) ShareShare
ReportReport
Posted on by CU14050944-0 2,721

Hi

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

  • Suggested answer
    Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: AX2012 R2 Dateformat, DD-MMM-YYYY in French

    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 :-)

    ktdmod.png

    regards

    Douglas

  • Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: AX2012 R2 Dateformat, DD-MMM-YYYY in French

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

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2012 R2 Dateformat, DD-MMM-YYYY in French

    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

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: AX2012 R2 Dateformat, DD-MMM-YYYY in French

    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;

    }

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans