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?
Competent Performer
Windows 10 
Access 2016
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?
VIP
Windows 10 Access 2010 32bit
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.
I am trying to calculate a persons age from DOB to a specific year afer "Enter date"
Trouble with query criteria for Date/time to return results for "Today"
"Date" in VBA Translates to "2010-06-22" Instead of Today's Date
Posting Permissions
Reply With Quote