how to calculate count of Quarters in dates?

Answers

• Options

  Arhontis Member Posts: 667

  2019-05-30 edited 2019-05-30

  Hello,
  
  Sample code on calculating full quarters between two dates:

  LOCAL CalculateQuarters(piFromDate : Date;piToDate : Date) rQuarterCount : Integer
    rQuarterCount := 0;
    lrDate.SETRANGE("Period Start",piFromDate,piToDate);
    lrDate.SETRANGE("Period Type",lrDate."Period Type"::Quarter);
    IF lrDate.FINDFIRST THEN
      rQuarterCount := lrDate.COUNT;
  

  
  Usage sample:

  MESSAGE(  
    FORMAT( 
      CalculateQuarters(010119D,311219D)
    )
  );
  

  
  As to where to use it, that would depend on your need...

  Regards,
  Arhontis
  
  https://forum.mibuso.com/search

  1