Date parameter query on timestamp field

[Guest]

I'm not sure if this is correct newsgroup or not; please let me know if I
should try another...

I have a timestamp field in a table, and I would like place a parameter on
this field for a query. Can I use some formatting function for this? I
thought "DateValue" might work, but it doesn't seem to.

Sample value in my timestamp field:

04/27/2005 11:59:26 AM

Can I use a parameter in my query to simply ask for a date (e.g., and user
enters "04/27"), and have it pull correctly?

 

[Nikos Yannacopoulos]

Adam,

What you need to so is add a calculated field in your query using
DateValue on the timestamp field; this will return the date part of the
stamp only, so you can then apply your date criterion on it.

HTH,
Nikos

 

[Guest]

Thank you.

Adam,

What you need to so is add a calculated field in your query using
DateValue on the timestamp field; this will return the date part of the
stamp only, so you can then apply your date criterion on it.

HTH,
Nikos