W
willh
I have a query that calcs the weekdays between 2 specific dates entered as
perameter values and calcs if they are less that 10 days. How to I get it to
ignore specic holiday dates (e.g .christmas) that maybe weekdays. Can I put
these dates into the expression or in a separate table which the query then
calls, or set up some criteria to ignore these specific dates in the weekday
calc. The query is below....
RLAMND Is Not Null And Between [Enter First Date] And [Enter Last Date]
Days Taken: WeekDays([DEPOSD],[RLAMND])
Target Met: IIf([Days Taken]<=10,1,0)
where DEPOSD & RLAMND are date fields in a table
I tried "and is not 25/12/2008" in the criteria but this didn't make any
difference
Cheers
perameter values and calcs if they are less that 10 days. How to I get it to
ignore specic holiday dates (e.g .christmas) that maybe weekdays. Can I put
these dates into the expression or in a separate table which the query then
calls, or set up some criteria to ignore these specific dates in the weekday
calc. The query is below....
RLAMND Is Not Null And Between [Enter First Date] And [Enter Last Date]
Days Taken: WeekDays([DEPOSD],[RLAMND])
Target Met: IIf([Days Taken]<=10,1,0)
where DEPOSD & RLAMND are date fields in a table
I tried "and is not 25/12/2008" in the criteria but this didn't make any
difference
Cheers