X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Date Grouping By Quarter - Format$    
post May 30 2008, 07:57 AM

Posts: 342
Joined: 19-September 02

I've used the wizard to generate a report that groups records by quarter. The default coding for the quarter is:
=Format$([MyDate],"Qq yyyy",0,0)
which returns Q1 2008 for the period 1/1/2008 thru 3/31/2008.
I would like Q1 to begin July 1 and have tried to adjust the "0,0" part of the above code, to no avail. Unfortunately, onboard help is no help.
Would someone tell me how to make the changes needed?
Thanks - Mike
Go to the top of the page
post May 30 2008, 09:08 AM

UtterAccess VIP
Posts: 2,224
Joined: 1-December 03
From: Lansing, MI USA

Unfortunately, I have never used the Q designator for quarters. I have always just figured it out myself. Our quarters start on October 1. In your case, I would have done this using my method.
=Iif(Month([MyDate]) Between 7 And 9, 1, Iif(Month([MyDate]) Between 10 And 12, 2, Iif(Month([MyDate]) Between 1 And 3, 3, 4)))
Go to the top of the page
post May 30 2008, 09:55 AM

Posts: 342
Joined: 19-September 02

Thanks Greg. That appears to fit the bill.
Go to the top of the page
post Jan 27 2013, 08:20 AM

Posts: 22
Joined: 4-June 07
From: Scotland (cold & wet)

Hi Just to let you know that I used your quarter code, neat solution to a problem. Thanks Alan Pollock, Scotland. (cold & damp)
Go to the top of the page
post Jan 27 2013, 11:04 AM

Access Wiki and Forums Moderator
Posts: 75,724
Joined: 19-June 07
From: SunnySandyEggo

Hi Alan,

Our fiscal year also starts in October, and I use this one:
=Format(DateAdd("m",3,[DateField]),"\Qq yyyy")

Just my 2 cents... :2cents:
Go to the top of the page
post Sep 18 2013, 09:31 AM

Posts: 24
Joined: 9-September 13

I definitely need this, but I'm not sure where I'd use this code.
Go to the top of the page
post May 14 2019, 04:57 PM

Posts: 1
Joined: 14-May 19

Thank You so very much for this Greg! It worked & I truly appreciate the time you took in sharing this with! That's why I enrolled in this forum, just to say THANK YOU!
This post has been edited by Angeles: May 14 2019, 04:58 PM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th July 2019 - 05:00 PM