[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: How do I know What Qtr of Year it is !

Here's a simplified version in 'SQR lingo':

let #qtr = round(#month/3+.33,0)

             -Tony DeLia


Anthony Leung-New York wrote:
>
> Quick alogrithm:
>
> 1. Get the Month
> 2. subtract month by 1
> 3. divide the result from step 2 by 3
> 4. get the integer part and add 1 to it. That will be your qtr.
>

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com