Printing Report (1 Viewer)

[mtp]

I'm trying to print a report which has to be difference dates for every month. What I have done is that my report only print out the right number when the close date is the beginning of each month (like every 30 days in circle) Example: when my closedate is 1/19/01 the report is not printed out information on that closedate. It printed out the information on 12/21/00??? Does any one knows why??? Here is what I used
Query's design:

Table FCLOSEMONTH
Field: CLOSEDATE
Criteria: Between StartOfMonth(Date()) And EndOfMonth(Date())
Illinois


Modules to apply in Query above:
Function StartOfMonth(D As Date) As Variant
StartOfMonth = DateSerial(Year(D), Month(D) - 1, (D))
End Function
Function EndOfMonth(D As Date) As Variant
EndOfMonth = DateSerial(Year(D), Month(D) + 0, 0)
End Function