Date/Time Parameter query (1 Viewer)

[Uvuriel03]

I have a table with a date field that I'm building a query for. It has dates in this format:

4/17/2009 10:40:03 AM
4/17/2009 1:25:37 PM
(m/dd/yyyy h:mm:ss AM/PM, I think)

I would like the query to ask for a date and have the query show all records from that date. However, because of the full date and time format of the field, I'm having trouble writing the appropriate parameter query.

Anyone have some input?
Thanks!

 

[Brianwarnock]

If you are requesting data from a date then >[thatdate] will suffice as a date without a time defaults to a time of 00:00:00

Or did you mean all data on a particular date?

Brian

 

[Uvuriel03]

Actually I figured it out. The problem is that my field *does* have date and time, so just doing a parameter with a date value wasn't working. I created a query field as follows:

DateParameter: DateValue([DATEOF])

[What Date?]

I had to add "What Date?" to the Query Parameters and change the type to Date/Time.

That did the trick. =)

 

[Brianwarnock]

Ok thats Good

Brian

 

[raskew]

Hi -

I'm probably a day late and a dollar short, but take a look at the
query I just posted here. It appears to do the job.

HTH - Bob