there are two DST's theirs and ours (except for Qld where we get enough sunshine, thankyou very much)
while the quick answer is probably dateAdd() do you care where the data entry user is logged in at? is this a personal profile setting? how about end user? you may be forced to take the US date/time back to UTC (GMT) and then forward to the users timezone. I'm working with a system right at this moment that stores all date/time as UTC time. Data entry from a user takes into account their profile (and therefore their UTC offset from where they are in the world) and adjusts the date/time accordingly to get to UTC date/time. Reading back data again takes the end user's timezone into account and again adjusts the UTC time accordingly. It's really heavy handed, sure, but this is an Enterprise system designed to be used worldwide. When something happens at a specific time, it needs to be consistent across the board. What's Rangoon to you is Grafton to me. On Mon, Sep 15, 2008 at 8:24 AM, Mark Mandel <[EMAIL PROTECTED]> wrote: > > But what happens when DST rolls around? > > Mark > > On Mon, Sep 15, 2008 at 2:30 AM, Matt Bourke > <[EMAIL PROTECTED]> wrote: >> I'm currently in a car so don't have any docs but can't the dateadd function >> add hours? >> M@ >> >> Sent from my iPhone >> On 14 Sep 2008, at 16:35, "Claude Raiola" <[EMAIL PROTECTED]> wrote: >> >> A website that is hosted in usa and so when Dateformat(now()) is displayed >> it outputs the usa date and time >> >> >> >> How can I add 17 hours to the date being output to bring the date time being >> displayed from the usa date time to australian date time on the cf page >> >> >> >> Kind Regards >> >> Claude Raiola >> B.Econ(Acc.); B.Hotel Mngt. >> Mobile: 0414 228 948 >> Phone: 07 3666 0981 >> Fax: 07 3319 6444 >> >> Websites: >> www.WebsiteSolutions.com.au >> www.AustralianAccommodation.com >> www.AccommodationNewZealand.com >> www.HospitalityPurchasing.net >> www.Samaris.net >> >> >> > >> > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
