some tests with date filters

[pvgenuchten]

Some queries work fine on demo, but not on our postgres backed instance, differences can be explained by the database?

after date; error: sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: text >= timestamp with time zone LINE 4: WHERE records.insert_date >= '2020-07-16T00:00:00+00:00'::ti...

using during keyword sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: text >= timestamp with time zone LINE 4: WHERE records.date >= '1969-07-16T13:32:00+00:00'::timestamp...

Seems the field is text, date type is expected?

I also tried date without T00:00:00Z, but then the code converted the date to an integer (1969 minus 07 minus 16 = 1946)