A Simple Query Filter !!! 1

[BAWC01]

Hi I have the following data in a date field


11/05/2003 01:00:00
11/05/2003 02:00:00
11/05/2003 03:00:00
11/05/2003 04:00:00
11/05/2003 05:00:00
11/05/2003 06:00:00
11/05/2003 07:00:00
11/05/2003 08:00:00
11/05/2003 09:00:00
11/05/2003 10:00:00
11/05/2003 11:00:00
11/05/2003 12:00:00
11/05/2003 13:00:00
11/05/2003 14:00:00
....
11/05/2003
11/05/2003
11/05/2003
11/05/2003
11/05/2003

What I want to do is select just the "11/05/2003" not the "11/05/2003 01:00:00"

How can I do this

Thanks

Phil

 

[easyit]

chek the format function

 

[BAWC01]

Simple but sweet

Thanks