One other thing about dates & Google Sheets: I have the properties of the cells in the
Scheduled column set to be Year-Month-Date Hours:Minutes:Seconds with 2 digits for everything except the year. If you double click a cell with a date in it, a calendar will pop up where you can click a different date. Problem is it'll either remove the preceding 0 from the hours:
2018-02-14 0:00:00
Or it'll shitcan the Hours:Minutes:Seconds completely:
2018-02-14
It's fucking
The way around this is to copy a cell with a date in it. Then double click the cell you want a date in & paste the date in there. Before you hit enter, edit the date by hand (try it & you'll see what I mean) You have to do this because TGPX must have the date like this:
2018-02-14 00:00:00
And it gets really confused if the date is like this:
2018-02-14 0:00:00