I always get a syntax error when I try to pull the year and month from a date.
My code in the query is
and
if I do the same with month it works. Am I doing something wrong?
My code in the query is
Code:
Year: Format([date]; "yyyy");
Code:
Day: Format([date]; "dd");