I have a query that takes two fields and combines them into one.
Rotate: [PRD] & " / " & [EAOS]
Right now the short date displays for both fields. I want the format for both fields for this query only to display like this MMM YY. I need the short date on other queries.
Is there a way to do it? And if so how?