To match current year, I’d use something like: WHERE dateformat(date(today), "YYYY") = dateformat(file.day, "YYYY")
WHERE dateformat(date(today), "YYYY") = dateformat(file.day, "YYYY")