Date/Time question

[vz]

Is there any ay to get rid of time when prompting for a date? i am using an access 97 db which had the data type date/time and i used a oledb connection. When i just choose date when i set up my parameters and then click set defaults to go to the next page it won't let me choose my field under browse table and field choose but when i choose date/time and go to set default values it will. Is there a way around this or can i somehow set the time default to be 12:00:00 am?
Thanks in advance

 

[Trainingjason]

Try converting to a date formula then passing it to a parameter.

 

[vz]

How do I do that?
Thanks