search

edwinmyp88 / accessdbdataingestor

0 stars 0 forks source link

Certain rows in MsAccess DB are not read and processed #1

Closed edwinmyp88 closed 2 years ago

edwinmyp88 commented 2 years ago

Refer to screenshot

image

tanhanweiii commented 2 years ago

This is because the read.py is get local date (GMT +8) to retrieve today data, but the data from MS Access DB is used GMT, so it will missing the data from (GMT) 16:00 until 23:59 due to local date already is new date.

Now this issue is fixed by modify read.py to get GMT date instead of GMT+8 date.