In a report header, I'm using "=Date()" to display today's date (mm/dd/yyyy), but I'd much prefer it to display the current quarter and year instead (i.e. "Quarter 4, 2021).
Is there an easy way to do that?
In a report header, I'm using "=Date()" to display today's date (mm/dd/yyyy), but I'd much prefer it to display the current quarter and year instead (i.e. "Quarter 4, 2021).
Is there an easy way to do that?
Assuming the year is based on calendar year and not some other arrangement such as a fiscal year might be.
="Quarter " & Format(Date(),"Q, YYYY")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.