Remove Time from DTPicker

[wordsmith]

Hi all,

I need to remove the time input from the DTPicker. i am using it as part of a data entry form and added it sometime after i created the form.

However, i now find that for any entries which were made using the DTPicker, the queries I run on the entered data does not pick up the entries made by the DTPicker because of the date format.

Is there anyway to remove the time? Or is there a way to design the query so it picks up entries made with the DTPicker?

help much appreciated.

regards

Keji

 

[MarkK]

Check out the DateValue() function.