Desmond I have this query: SELECT A,E,H,P,R WHERE A IS NOT NULL AND YEAR(A)=2022 How can I replace the hardcoded 2022 by dynamic current year?
Support from Sheetgo Desmond try this one: SELECT A,E,H,P,R WHERE A IS NOT NULL AND YEAR(A)=YEAR(TODATE(NOW()))