What is the best way to take the date part out of a datetime field and keep it as a date? I am able to use the convert() but then later in my VFP querey I have to change the field back into a date from a string. Is there another way to get this done?

Thanks in advance
Kelly