2.4b Spreadsheet Fix (PostgreSQL)

[New York Jet]

I upgraded my PT to use PostgreSQL. I figured out how to update the username and password in the VBA code (see here (http://forumserver.twoplustwo.com/showflat.php?Cat=&Board=singletable&Number=2827062 &Forum=&Words=&Searchpage=0&Limit=25&Main=2718711& Search=true&where=bodysub&Name=16130&daterange=1&n ewerval=1&newertype=w&olderval=&oldertype=&bodypre v=#Post2827062)). It works fine as long as you remove the date from the "Ignore tournaments started before" field before importing. If you leave the date in there, you will receive a runtime error "syntax error at or near "11" at character 280. The 11 is the number in the hours position within the time, 11:30:00 PM It would be great to get it working as it did in the past so that I can exclude tournaments prior to this year. Anyone know how to fix this?

[New York Jet]

bump

[astarck]

I just made the switch to the new PT db and changed what you said to change in the spreadsheet. That part works fine.

I'm running into a problem now where the spreadsheet wants to say I played the STT at 10:00pm when I actually played it at 9. This is only in the spreadsheet and the time appears correctly in the PT database and the problem has only happened for imports since the new db. I'm thinking an easy fix would be to subtract 1 somewhere around the timezone code but I can't figure out exactly how to do it.

Does anyone know how to fix the code so my STT times will be correct in Excel?