# Thread: 3rd Qtr (A2K)

1. ## 3rd Qtr (A2K)

I have 1st qtr logic:

Between DateSerial(Year(Date()), Int((Month(Date()) - 1) / 3) * 3 + 1, 1) and DateSerial(Year(Date()), Int((Month(Date()) - 1) / 3) * 3 + 4, 0)

and 2nd Qtr Logic:

Between DateSerial(Year(Date()),Int((Month(Date())-1)/6)*3+1,1) And DateSerial(Year(Date()),Int((Month(Date())-1)/6)*3+4,0)

but can't seem to get 3rd qtr logic correct...can someone help me here?

Thanks....

2. ## Re: 3rd Qtr (A2K)

I don't understand - the first expression doesn't test for 1st quarter, but for the current quarter (at this moment 10/01/2006 through 12/31/2006).
The second expression tests for the first quarter if the date is in the first half of the year, and for the second quarter if the date is in the second half of the year. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

3. ## Re: 3rd Qtr (A2K)

I am not sure what you are trying to do, but I suggest you look at <post#=599,970>post 599,970</post#>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•