Date column showing invalid despite no validif check

[Robjmsw]

See screenshots below.

I added a table based off a google sheet that has minimal formatting done to it. I have a [Date] column, with a "Date" column type, however whenever I enter a date into the form for the sheet it will tell me that the column is invalid.

HOWEVER this error only occurs when I click into the box while there is a value in there. For example:

If I use today() as the initial value, then touch the box I will be told that date and any future dates are invalid. However, if I was just to leave it as today(), it would work fine.

If I leave the box blank and directly enter a date into it, it will format it properly and let me save it. But, if I click the box again after entering data, it will give me the "This entry is invalid" error.

Additionally, in the form the calendar date button you can press to select a specific date is greyed out.

I have tried saving the date column as a different type then reverting it, regenerating everything. Not really sure what the next step is, any help is appreciated