Hi all,
I have a long date which includes time stored in a database ie 12/07/2004 19:35:00. If i wanted to search just the date out of this entery i do a search on 12/07/2004, how would i accomplish this, does the datepart function allow this?

thanks for you help
Paul

Looks like you are using access. Try this

Format ([DATECOLUMN_NAME], "yyyy/mm/dd")

Cheers!

_________________________
- Vijay G
Strive for Perfection