In my table I have a DateTime field, it only contains Dates. In the format of mm/dd/yyyy - In a query I need to display this field - then in the next query field I need to add one year to the field.
Example if the table holds 02/24/2020 then I want the next query field to show 02/24/2021
How would I add one year to a field in a query?
I tried this, but I get the error 'The expression you entered contains invalid syntax'
Code:Anniversary: DateAdd("yyyy", 1, [Joined]);