Save date as blank

[LoveLEE143]

Hello I am building a database for a client who manufactures car parts. I have a table to store vehicle model. Each model has a date range of production. I have two build dates from and to. Both of these fields are setup as date fields on the table. I made both fields required with a mask for validation. In the "build date to" field if a car is still in production I need to leave the field blank. Is there any special character that will allow me to store a required field blank.

[June7]

No - if field is set as required then must enter value.

Since data is not always required, don't set as required.

Can use code to validate data. Determine at what point it is necessary to verify this date is provided and write code to handle that.

[LoveLEE143]

Thanks problem solved.