My first ever post!! - although I often look here for solutions.

Can find any help on this one:

I am trying to select all records from an orders table where the date is equal in part to an entered date. ie.

User posts Date: '16/mar/04' or '16/03/2004'

My database has the date stored as '16/03/2004 10:29:01' and come back with no records.

I would like it to return all orders on that date irrespective of the time. I also don't really want to put the order time in a separate field. Any ideas ??

I have thought about using LIKE #16/03/04%# but the syntax is incorrect - am I opn the right tracks ??