>>How do I clear a date field and a datetime field
>err ...
>
REPLACE dDateTime with {}
>
>My test was a PM date time. The "{}" cleared the date and time, but replaced "PM" with "AM"
AM and PM don't make sense, anyway. Why is 0:00 PM but 12:00 is AM (or vice versa, I wrote it down once because I couldn't memorize it...). The whole thing is as logical as english grammar.
The {} will give you 0:00:00... now how it displays is up to your silly calendar with 730 halfdays.