There is always an easier way but here’s one
In query/400 Define Result Fields
CURDATE year(current(date))*10000 +
day(current(date)) – 20000000
That creates a new column containing todays date … today it contains 081219
You can compare your date column with this column. The equations will have
to be adjusted in 91 years.