Hi,
I have a date value i.e 29/09/2005,
I understand that I can format this in the underlying query to be just 2005. So I can Order by it.
Printable View
Hi,
I have a date value i.e 29/09/2005,
I understand that I can format this in the underlying query to be just 2005. So I can Order by it.
have you tried Year(Field)?
In the query designer in the field column it tried
YEAR(DATE OF DELIVERY)
It tells me the expression I entered contains invalid syntax.
Works.
InstallDate: Year([DATE OF DELIVERY])
If your field name have spaces then it's a rule to enclose them in brackets... ;)
Glad it worked. :)