Results 1 to 3 of 3

Thread: 3rd Qtr (A2K)

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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....
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    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#>
    Regards
    John



Posting Permissions

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