View Single Post
  #41  
Old 09-02-2005, 02:46 PM
maddog2030 maddog2030 is offline
Senior Member
 
Join Date: Feb 2005
Location: Virginia Tech, $33s
Posts: 200
Default Re: NEW Spreadsheet: 2.4b w/ Daily Summary

I'm going to bring this back from the dead because I switched to PT PostgreSQL and noticed the start times were an hour off in the spreadsheet. Here is a quick fix if anyone wants it:

Change
<font class="small">Code:</font><hr /><pre>stSQLStatement.CommandText = "Select MIN(date_played), MAX(date_played)" &amp; _</pre><hr />

to
<font class="small">Code:</font><hr /><pre>
stSQLStatement.CommandText = "Select MIN(date_played) - INTERVAL '1 hours', MAX(date_played) - INTERVAL '1 hours'" &amp; _</pre><hr />
Reply With Quote