Count Days...

[sdc1234]

Greetings, I have a count days querry that counts the # of days per calander month, the problem I am having is that on the month of Oct 19-Nov 30 keeps pulling 3001 days, can you assist: code I am using is :

Class Length: IIf(Len(Trim([EMI_Courses_ALL]![CourseDates]))<=11,Val(Right(Trim([EMI_Courses_ALL]![CourseDates]),2))-Val(Mid(Trim([EMI_Courses_ALL]![CourseDates]),4,3)),Val(Right(Trim([EMI_Courses_ALL]![CourseDates]),2)+Mid(Trim([EMI_Courses_ALL]![CourseDates]),4,3))-Val(Mid(Trim([EMI_Courses_ALL]![CourseDates]),4,3)))+1

[lfpm062010]

Are you trying to count number of days between 2 dates?

If that is the case, why don't you use "DateDiff"?

=DateDiff("d", [Date1], [Date2])