Extract Date from Timestamp

[joeserrone]

I have a timestamp field in a database and only want to display the Date. In the query I placed this: Date Received: Format([RItemTimeStamp],"Short Date")

Works fine however if I try to run a query to serach for a date range it doesn't give me all the days. Is there a better way how to truncate the Date of a timestamp so that I can sort it correctly?

 

[jzwp22]

You could try the datevalue([RItemTimeStamp]) function.