Datediff question (RESOLVED)

[cajsoft]

Hi,
I am writing a small helpdesk utility and wish to report the number of calls resolved within seven days. The code below works great but I'd like to be able calculate the first day as monday. e.g, show all calls resolved from last monday

anyone help me please?

if DateDiff("d",ors.fields("ResolvedDate"),now)<=7 then
	    resolvedin  = resolvedin + 1
end if

[dj4uk]

Just to clarify...

If you wanted to view calls resolved for this week that would cover Monday 12th and Tuesday 13th.

If you wanted last weeks numbers that would be between Monday 5th and Sunday 11th.

Does this sound right?

DJ

[cajsoft]

Yes Thats correct.. each week I want to show calls resolved from previous monday through to sunday night.

[davebat]

Try:

if DateDiff("d",ors.fields("ResolvedDate"),now,2)<=7 then
	    resolvedin  = resolvedin + 1
end if

By adding the 2 into the function you are telling it the first day of the week is a Monday, is this what you meant?

[cajsoft]

Originally posted by davebat
Try:

if DateDiff("d",ors.fields("ResolvedDate"),now,2)<=7 then
	    resolvedin  = resolvedin + 1
end if

By adding the 2 into the function you are telling it the first day of the week is a Monday, is this what you meant?

It's still showing more calls resolved than there should be. Only 7 calls were resolved since monday, but it's showing all calls from 7 days ago.?

[davebat]

try this then, it will look back to the p[ast seven days as you have hard coded this number in. Use a variable instead.

<%
V_DAY = weekday(date(),2)

if DateDiff("d",ors.fields("ResolvedDate"),now,2)<= V_DAY then
	    resolvedin  = resolvedin + 1
end if
%>

I think the easiest way to do this would be within the sql, so that it only pulls out records that fallw ithin the two dates. If you need help doing this let me know.

[cajsoft]

Cheers mate. Thats whay I was looking for.