Lisa, It's quite simple actually. The Date/Time that is stored in a Date/Time field is correct and adjusts based on the client view of data (what tz/dst/etc) is currently in effect. The values stored in character fields (the right hand box in your image) is just that, text, and doesn't adjust for anything. I don't think there is anything you can do to 'fix' this unfortunately.
On Thu, May 16, 2013 at 5:23 AM, Lisa Singh <lisa.si...@gmail.com> wrote: > I'm noticing an odd thing with Audit Logs in Changes - while the > "Audit Date" date and times are always correct, the date time items > from the Change Request itself are always an hour out. > > I suspect that's something to do with UTC vs GMT being an hour > different at the moment, but why would the Audit Dates and times be > correct and only Scheduled, Actual and Requested Dates be recording an > hour different? Is the Audit date just pulling in the Modify Date from > the CHG record whereas the scheduling lives in a different > form/table/service somewhere? > > (see attached). > > This is driving the Change Team mad, I'd love to be able to resolve this > one... > > Thanks for any help, > > Lisa > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
