Setting Date column to the current date

Just use Now() as you would for a DateTime

  MyDateColumn = NOW(),

WHERE based on a date

The same as for a DateTime column:

  WHERE MyDateColumn < DATE_SUB(now(), INTERVAL 180 DAY)