#26
|
|||
|
|||
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 /> |
|
|