X++ Coding: How to calculate the working days?

[ffchen]

Hi all,

I would like to calculate the working days from 1 Feb to 25 Feb 2012, is any function that I could calculate the working days, thanks.

Best Regards,

MC.

[raj.verma]

Hi Michael ,

you have to use a calendar (Basic > Calendar) to define working days (you can even use different calendars for individual vendors, for example 14 Feb is holiday . With a calendar, you can call the WorkCalendarSched class, method schedDate().

[ffchen]

Hi Rajkumar,

Thanks for your help. I have set the Base–> calendar for working days. If I would calculate the working days between 13/2 to 19/2. Assume 14/2, Saturday and Sunday is holiday. Any function or coding could help to solved it.

Thank you very much for your help.

[Tommy1]

Hi Michael,

I have the problem same to you. Now, I don’t know solve how? Did you solve of this problem? If ok, please help me.

[srikanthvuthu]

there is class > TSPeriod in ax 2012 it might usefully for you.

[Tommy1]

Hi srikanth,

That is useful share, but i using Ax2009**.**

Thank you your reply.

[Willem81]

Ok, so I made the following simple code that works (AX2012). My calendar name is “Standaard” I hope it will help someone:

static void WorkingdaysInPeriod_WD(Args _args)

{

WorkCalendarSched workCalendarSched;
date start;
date end;
counter workingdays;
counter totaldays;
CalendarId primCalendar=“Standaard”;
;

start=str2date(“1-11-2014”,123);
end= str2Date(“1-12-2014”,123);

workCalendarSched = new workCalendarSched();

while(start<end)
{

totaldays++;

if(workCalendarSched.isdateopen(primCalendar,start)==true)
{
workingdays++;
}

start++;

}

info(strfmt(“Total days: : %1”,totaldays));
info(strfmt(“Total working days: : %1”,workingdays));

}