QUERY OR FUNCTION TO CONVERT DATE TO AN EXPRESSION

FYI. If you were doing standard quarters of a year that is already built in to the format function
"Term " & format(date,"q")
Term 4
Unfortunately there is no constant for a 3rd of a year only a quarter of a year.
 

Users who are viewing this thread

Back
Top Bottom