>>>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.
If I'm not mistaken, AM is "ante meridian" (before midday) and PM is "post meridian" (after midday). Perhaps the confusion does come about partly because 24-hour notation is zero-based, whereas the 12-hour clock tries to avoid the zero and calls it 12. A 24-hour time of 00:00:00 would correspond to 12:00:00AM, while 12:00:00 would correspond to 12:00:00PM.