Printable View
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?
Code:if DateDiff("d",ors.fields("ResolvedDate"),now)<=7 then
resolvedin = resolvedin + 1
end if
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
Yes Thats correct.. each week I want to show calls resolved from previous monday through to sunday night.
Try:
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?Code:if DateDiff("d",ors.fields("ResolvedDate"),now,2)<=7 then
resolvedin = resolvedin + 1
end if
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.?Quote:
Originally posted by davebat
Try:
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?Code:if DateDiff("d",ors.fields("ResolvedDate"),now,2)<=7 then
resolvedin = resolvedin + 1
end if
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.
Code:<%
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.
Cheers mate. Thats whay I was looking for.