Hi Greg, this works, thanks so much! The one problems is I have to add the "-5" for it to work, and it current displays the tip for today 1/8/11 but shows 1/9/11 as the date. I assume that the new tip this way will be updated at 12:00 am Hawaii time?
I put the code on this page: http://www.gotnutrients.net/dailytips_test.cfm <!--- code---> <cfset tipdate = now() /> <cfset offsettime = dateadd("h", -5, tipdate) /> <cfquery name="rs_dailytip" datasource="#REQUEST.dataSource#"> SELECT record_id, tipdate, dailytip, consumer_link,consumer_text, research_link, research_text FROM dailytips WHERE tipdate = <cfqueryparam cfsqltype="cf_sql_date" value="#offsettime#" /> </cfquery> <!--- check if there is a tip for today, sidplay, or display error message---> <cfif rs_dailytip.recordcount> Today's Daily Tip:<p> <cfoutput><em>#DateFormat(tipdate,'mmmm d, yyyy')#</cfoutput><br /> <cfoutput>#rs_dailytip.dailytip#</cfoutput><p> Consumer Related Article:<br /> <cfoutput><a href="#rs_dailytip.consumer_link#"> #rs_dailytip.consumer_text#</a></cfoutput><br /> Research Related Article:<br /> <cfoutput><a href="#rs_dailytip.research_link#"> #rs_dailytip.research_text#</a></cfoutput> <cfelse> No Daily Tip Today! </cfif> <p> I am trying to get the tip to display at 12:00 AM in Hawaii, but the server is located in Delware, the ideal situation is to add 5 hours so the tip is not displayed until 12:00 am in Hawaii <p> <b> Server Information</b><br /> <cfoutput>#DateFormat(Now(),'mmmm d, yyyy')#</cfoutput >Delware Date<br /> <cfoutput>#TimeFormat(Now(),'hh:mm tt')#</cfoutput> Delware Time<br /> <p> <b>Hawaii Information</b><br /> <cfoutput>#DateFormat(offsettime,'mmmm d, yyyy')#</cfoutput> Hawaii Date<br> <cfoutput>#TimeFormat(offsettime,'hh:mm tt')#</cfoutput> Hawaii Time<br /> <p> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5188 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
