>>>>>>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.
>>
>>
>>how can 12pm with is meridiam be past meridiem???
>>
>>P
>
>This is because they need to invent 0. 24hour system runs from 0:00:00.0 to 23.59.59,99 So they end up with 12 and 12 and need to differ both see http://en.wikipedia.org/wiki/12-hour_clock#Confusion_at_noon_and_midnight

Don't forget http://en.wikipedia.org/wiki/Leap_second

;)