Problem Comparing Dates!

[Coolboy55]

I have a general date field in a table. When a user opens a particular report, a form opens that asks them to enter a date (short date format) to filter the report by. I want the report to display all records with a date less than or equal to the entered date.

Of course, the problem is that the date entered (in other words, the "equal to" case) returns no data since the general date is LARGER than the short date for the same day since the time portion of the general date adds a decimal to the date value.

How can I compare the general date to the short date and retrieve records when the days are equal? I've tried using Format(GeneralDate, "Short Date") in the comparison but it does not work for some odd reason. I'm even displaying the result in a new column and the formatted general date result looks correctly like a short date, but the "equal to" records are still missing.

:!

[NeoPa]

The simple answer is to use DatePart() where necessary. More than that I cannot say as I have no idea what your current code is so I have no idea how you're thinking.

[dsatino]

Just programatically add 1 day to the user entry and switch your comparison operator to <. This will work because the time value of the short date is 00:00:00.

[Coolboy55]

Thank you both for your answers. I ended up using both solutions at once, but for different things. Thanks again!