Mostly for Tony Weeg's benefit, this turned up on the BACFUG list and it answers Tony's question about the dateAdd() bug.
Begin forwarded message: > From: Tariq Ahmed <[EMAIL PROTECTED]> > Date: Fri Jul 18, 2003 08:14:45 US/Pacific > To: [EMAIL PROTECTED] > Subject: Re: [bacfug] bug in MX with respect to time calculations > Reply-To: [EMAIL PROTECTED] > > Something like, produced the expected results. I don't > know if this matters, but we're getting an Epoch value > from a Remedy system that is stored in GMT. > > <CFSET Variables.localDSR = DateAdd("s", > GMTEpochValue,DateConvert("utc2Local", "January 1 1970 > 00:00"))> > > #DateFormat(localDSI,"Mmm d yyyy")# - > #TimeFormat(localDSI,"h:mmtt")# > > > > --- Sean A Corfield <[EMAIL PROTECTED]> wrote: >> On Wednesday, Jul 16, 2003, at 13:51 US/Pacific, >> Tariq Ahmed wrote: >>> Hey Sean, thx. Just wanted to know if this was a >> known >>> thing. I updated that code I adopted to >> dateconvert to >>> utclocal and the result looks accurate, so I'm >> good on >>> that front. >> >> Could you share the code you used that gave a >> correct date/time please? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4