Date range excluding Satrudays & Sundays 1

[routine]

I need to read a date range and then return the days
excluding Saturdays and Sundays

 

[ShankarJ]

Hi!

CASE (<ChosenDate> % 7)
OF 0 ! Sunday
OF 6 ! Saturday
ELSE
! do what you want
END

As a Filter ::

<ChosenDate> >= <FromDate> AND |
<ChosenDate> <= <ToDate> AND |
INRANGE((<ChosenDate> % 7),1,5)

This will work for an ISAM database like Topspeed but you may need something different for SQL databases.

Regards

 

[routine]

What is the <ChosenDate> the routine refers to?

 

[ShankarJ]

Hi!

The Date Variable/Column you are comparing from the Date Range i.e.

LOOP Date# = DATE(1,1,2010) to DATE(12,31,2010)
  CASE (Date# % 7)
  OF 0 ! Sunday
    Sundays# += 1
  OF 6 ! Saturday
    Saturdays# += 1
  ELSE
    IF <PublicHoliday> ! use your own method to find out if it is a public holiday
       PublicHolidays# += 1
    END   
  END
END

Regards