Date parameter query on timestamp field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thank you.

Nikos Yannacopoulos said:
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
Click to expand...
 
Back
Top