I am trying to select a recordset based on a date/time field. The parameter I want to use is the current date without the time. I have tried using the Date() function and typing in a specific date. Even though that date is present in the table I am querying the query returns a blank recordset unless I copy and paste the exact date, which includes the time as well. I don't want my query to be that specific though. I am using the short date format in my table but that does not affect the data itself. Any suggestions?

Justine,

Create a new field in your query using the following (change the field name to be reflective of yours):

DateField: Left([DateTimeStampField],InStr([DateTimeStampField]," "))

Pass your parameter to this column as it is only looking at the date value.

Regards,

Beth M

I ended up using DateOnly: DateValue([FREEZE_DATE]) in my calculated field with the date as the criteria. It works perfectly. Thank you so much for your help.

hello everybody,

i am using access for my application. now i am trying to draw charts based on the data in db. now the problem is how i can get the data's between the specified month and year. is there any function to get the data's in the range of month.

thank u.

siva