>>>>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
Peter Cortiel