Two Plus Two Older Archives

Two Plus Two Older Archives (http://archives2.twoplustwo.com/index.php)
-   One-table Tournaments (http://archives2.twoplustwo.com/forumdisplay.php?f=34)
-   -   NEW Spreadsheet: 2.4b w/ Daily Summary (http://archives2.twoplustwo.com/showthread.php?t=279970)

maddog2030 09-02-2005 02:46 PM

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


All times are GMT -4. The time now is 08:46 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.