I've looked for a straightforward way to add an hour to the Date/Time, but haven't found that yet. Is there a function to add time to a Date/Time (that I couldn't find)?
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: May 22, 2007 6:22 PM To: [email protected] Subject: Re: Extracting Date from Date/Time Field - need help! Since all you want is the date (and all oof your dates went in at 12 midnight) you can add an hour (or more) to your Date/Time value before moving it to the Date field. That should guarantee you are in the correct date. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Morris, Dave (MOH) Sent: Tuesday, May 22, 2007 5:01 PM To: [email protected] Subject: Extracting Date from Date/Time Field - need help! ** 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<image001.jpg>>
<<image002.jpg>>
