Skip to main content

Calculate the week Days ,week Ends between two date intervals In Ax 2009

By

How to Calculate the total number of weeks,weekends or count of  Sundays in a given date interval.. 


static void calcDays(Args _args)
{
    FromDate    fromDate    = today();
    ToDate      toDate      = mkdate(31,01,2011);
    WeekDays    weekDay = WeekDays::Sunday; // the day we search after
    int         days;
    int         cntSpecDay;
    int         leadIn;
    int         leadOut;
    ;
    days = fromDate - toDate; // days difference
    //Calculate the No.Of weeks in given Date Intervals
    leadIn = any2int(fromDate - toDate) /7;
    cntSpecDay = days / 7; // how many sundays in complete weeks
    if (dayOfWk(fromDate) <= weekDay)
    {
        cntSpecDay++; // the day we search is in lead in week
    }
    if (dayOfWk(toDate) >= weekDay)
    {
        cntSpecDay++; // the day we search is in lead out week
    }
info(strfmt("%1 is %2 times embedded between %3 and %4", weekDay,cntSpecDay, fromDate, toDate));
  print days;
  print leadIn;
  pause;
}

Out put:
======
786== Days
112== Weeks
Sunday is 113 times embedded between 3/27/2013 and 1/31/2011

Comments

Post a Comment

Popular posts from this blog

Using File path on a form getting Error in Axapta

By
Hi Folks, After a long time am coming  back to posting few new things here for AX Developer... When we want to select the file path in form level. Normally what we will do create one EDT and extends with filepath (EDT), but that time when you are trying to select the path we will get error like stack-trace/Error message .Don’t worry there is no problem with your ax application. Simple we need to provide the method to the form like filepathLookUpTitle (). Below method we need to add it into form level methods, i.e. str filePathLookupTitle() {     return "Select document folder"; } Thanks Happy Daxing....
20 comments
Read more

How to send Normal AX Reports to User through Batch Process in Dynamics Ax 2009.

By
Hi friends, Recently I got one requirements from my User, I.e. customer want to see ax reports in E-mail everyday once through batch process. its just like send mail from batch process only, But we need to work on how to send normal report. 1) write the class with below methods mandatory.           2)Here am going to post logic for how to convert ax report to PDF and how to send the email to user only. // Saved the reports into particular location void SaveReport() {     Args args;     ReportRun rr;     str reportName = "OpenPurchOrderLine_Vendor";     str myPath;     int i;    ;    i = 1;   args = new Args(reportName);   args.caller(rr);   rr = new reportRun(args);     rr.query().interactive(false);     rr.report().interactive(false);   ...
5 comments
Read more
By
 Note 2 ==== SE24 - Global class (Class and methods)  SE37 - function module - configure  SE38 - report  BAPI -  Function module  Object Type  Interface type  Form  - Flow  Form open - FP_Job_ open spool; function              LV_fm_name - cal function Job_close =============== ASN order confirmconfirmation  - VA03  FP_job_open VL02n - ASN  VF03  - Invoice document  VA02  - Sales order confirmation  Interface we cant debug - use Break-point from dev and activate then debug
Post a Comment
Read more