We've imported our Dates into a Date/Time field, and we're now running into problems with dates in the "3 weeks early" Daylight Savings Time (DST) change. The Date went in as the specified date at 12:00:00AM, but when we extract a date between March 11 and April 1 inclusive the hour is decremented to 11PM the day before and the day is decremented by one.
I've created a new field that is a Date field and moved the contents of the Date/Time into date, guessing that the time would simply be truncated, but the DST calculation takes place first and I get the wrong date! We're a few patches behind in Server 6.3 (currently at Patch 12), but patching up to the current level is presently not an option. Has anyone worked out a solution to this (interesting but annoying) problem? Dave Morris Ontario Ministry of Health and Long-Term Care Health Services Programs I&IT Branch Health Services Cluster 49 Place d'Armes, 4th Floor Kingston, Ont. K7L 5J3 * (613) 548-6473 / *Fax: (613) 548-6539 *<<mailto:[EMAIL PROTECTED]>> __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<image001.jpg>>
<<image002.jpg>>
