Delete a column of Dates

[BADebbie]

I have a column in my query that is for a date. The dates have all passed and I would like to delete these dates, but keep the column. I will be putting dates in there again in 2016. Is there a way to do some type of mass delete or update for this column or cells in the column?

Example

Q3 Zero Harm Lunch
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/24/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/19/2015
11/24/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/12/2015
11/24/2015
11/24/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/24/2015
11/24/2015
11/24/2015
11/24/2015
11/12/2015
11/19/2015
11/24/2015
11/12/2015
1/1/1900
11/18/2015
11/12/2015
11/24/2015
11/24/2015
11/12/2015
11/12/2015
11/12/2015
11/12/2015
11/24/2015
11/18/2015
11/19/2015
11/12/2015
11/18/2015
11/12/2015
11/12/2015
11/18/2015
11/18/2015
11/12/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015
11/18/2015

[June7]

Can run a DELETE sql action.

DELETE FROM tablename WHERE [fieldname] < Date();

Use Access query builder.

[pervezjan]

It is simple just Replace the Date column with 2016. If you need column just replace with null

[orange]

SQL DELETE is for deleting records.
If you just want to change the date from, say 2015 to 2016, then use an UPDATE query

UPDATE MyTable
SET MyDateField = 2016
WHERE MyDateField = 2015

More info on SQL DELETE