Yes, it is always difficult to use dates in SQLite... DuckDB makes dates easier - like they should be!