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)" & _</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'" & _</pre><hr />
|