Get weekdays and weekends in a month

[tis707]

Hi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .........,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays ---- 1,Weekends -------- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

Thanks

[sraheem]

Hi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .........,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays ---- 1,Weekends -------- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

Thanks

Try putting dates of that month in details section and then use dayofweek crystal function to find whether it is a weekday or weekend in a formula which return 1 then sum them. thats it
i know not the best way.