Printing Dates on a report in Access2000

[cbarrol]

I'm trying to print Beginning Date and Ending Dates on the top of a report.

1. I started by creating a form with unbound text boxes to enter the dates.
2. I then used then accessed the form in a query. I set the dates in the parameters listing.
3. On the criteria line in my query I have the following statement Is Not Null And Between[Forms]![ReportDateBox]![BeginningDate] And [Forms]![ReportDateBox]![EndingDate]

The query runs but returns dates outside the range.

Thanks!
C~

 

[LittleSmudge]

This could well be because of JET myopic view of the world when it comes to dates.

Regardless of the international setting on your PC ( that defines how a date is formatted and displayed ) JET will try to make the date fit into the confusing American MMDDYYYY forat if it can.

The solution is to ALWAYS format dates into Medium Date format when feeding them into anything that JET will get to chew on.

Eg.
Between _
Format(Forms!ReportDateBox!BeginningDate, "Medium Date") _
And _
Format(Forms!ReportDateBox!EndingDate, "Medium Date")


'ope-that-'elps.





G LS