Hi all, I had a query that was working but has since broken due to one of the tables being moved, now I can't get the DatePart function to work.
I'm trying to get the year from today's date by using the expression Year: DatePart("yyyy",Date())
This was working before, (although for some reason...