Update date field, one Month off

Hi,
I have a database with a date field,
when I do a basic update query to update a record with a new date, the Month is one Month off…
Say I insert 2021-03-24 in the database it becomes 2021-02-24. And when I insert a date in January, say, 2021-01-15 the database record becomes 1970-01-01

I cannot figure out why this happens. Perhaps anyone know why this occurs?

M