I want to convert dd/mmm/yyyy to MMM/YYYYY in my query. The audit date format in Table is 99/99/0000;0;_
I created; Inspection Due: [Audit Date]+364 in the query. I want to show the next inspection is due in 1-year but only show the Month and Year.
I tried to have the table show the change but can't get it to work there either.