mysql date field removing record

I am using mysql db
I want to be able to create a date field
which will create a date of today plus 90 days.

This should cause a record to disappear from a results list after 90 days.

Can anyone advise the best way of achieving this please?

Many thanks
John

in the database, use a timestamp column type for the date, and set the default value to:
CURRENT_TIMESTAMP

this will store the current date when a record is created.

then in the recordset you filter out records that are over 90 days old in the WHERE clause using:

WHERE dateColumn + INTERVAL 90 DAY >= now()

Thanks Jason
When I did that and tried to save it brought an error message.
I attach an image which I hope demonstrates the problem.
Regards
John

uncheck the allow null option

Sorry to say that did not change the error message still appears, I also tried unticking the box for On Update Current_timestamp.
Thanks
John

I believe there's no length parameter to timestamp.
I now have 0 zero
I also had to untick the box On Update Current_Timestamp
That seems to work OK

glad to hear it is working.