[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 !
- Subject: How do I know What Qtr of Year it is !
- From: Dominick LoGiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU>
- Date: Thu, 8 Apr 1999 11:31:55 -0700
- References: <199903302002.PAA24528@gateway2.ey.com>
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