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

How do I know What Qtr of Year it is !



I am writing an sqr that needs to look for qtr data. Example if
I ran today the run date I have is formatted like this 19990408. I can substr 
out
the month as 04.  Using 04 I need to look on a table if the date is '01' or 
'02' or
'03'. Based on the run date the qtrs I need to look for will always change.  I 
next
run this sqr in July so my qtr rundate will be 07 so I need to look for '04' , 
'05' or
'06'.  Is there a delivered sqr to do this.
I guess the short story is I need to know what 3 months are the previous qtr.
thanks