Microsoft Dynamics AX (Archived)

Split Date Between From and To date in AX 2012 X++ code

(0) Share

Report

Posted on by Karthik Desappan

5,680

Hi All,

I have created Dialog with Two fields:

From Date : 01/01/2014 -- given Jan

To Date : 31/03/2014 --- given march

after given from and to date in dialog field and click ok button in dialog.

when closing dialog with filled from and to date above given I need to display date in info in the below format:

info - 31/01/2014 ----last date of month in jan

info - 28/22014 ----last date of month in Feb

info - 31/03/2014----last date of month in march

the above I explained how to split date from two different date withdate display last date of month.........

plz let me know any one face about this..........

Thanks in Advance,

A.D.KARTHIK

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

ArunGarg 3,926 on at

Like (0)

Report

Hi karthik,

Please refer below links:

dynamicsuser.net/.../365021.aspx

tech.alirazazaidi.com/some-usefull-date-functions-in-dynamics-ax-x

community.dynamics.com/.../number-of-months-between-two-dates-in-dynamics-ax-2012.aspx

May be this link can help you :-)

Regards

Arun

Was this reply helpful? Yes No
Verified answer

Abhimanyu Naruka 160 on at

Like (0)

Report

Hi Karthik

To get last dates of month you may use "static date dateEndMth(date transDate)".

Can provide some more example to explain your split date problem

Was this reply helpful? Yes No
Verified answer

jasman 1,413 on at

Like (1)

Report

date dfrom = 01\01\2014;

date dto = 31\03\2014;

date dcalc;

date lastDayInJan;

date lastDayInFeb;

date lastDayInMar;

dcalc = mkDate(1,mthOfYr(dfrom),year(dfrom)); // 1st date of chosen mth/yr

dcalc = nextMth(dcalc);

lastDayInJan = dcalc - 1; // Last day in month (january)

dcalc = nextMth(dcalc);

lastDayInFeb = dcalc - 1; // Last day in month (february)

dcalc = nextMth(dcalc);

lastDayInMar = dcalc - 1;

info("Last date in january: "+queryValue(lastDayInJan)+"\nlast date in february: "+queryValue(lastDayInFeb)+"\nlast date in march: "+queryValue(lastDayInMar));

Was this reply helpful? Yes No
Verified answer

Jonathan Halland 11,310 on at

Like (3)

Report
date tmpEnd = endMth(startdate); do { info(strFmt("%1", tmpEnd)); tmpEnd = endmth(nextMth(tmpEnd)); } while (tmpEnd <= endmth(endDate));

OR

date tmpEnd = endMth(startdate); do { info(strFmt("%1", tmpEnd)); tmpEnd = endmth(nextMth(tmpEnd)); } while (tmpEnd <= endDate);

Was this reply helpful? Yes No
jasman 1,413 on at

Like (0)

Report

I was quite old school there (remnants of my XAL coding days).

Of course the endmth intrisic function is the way to go. :)

Was this reply helpful? Yes No