Determining quarter number

Offshored2002 · Post by **Offshored2002** » Tue May 06, 2008 6:08 am

Is there an easy way to determine the number of quarters between two dates which could be added as a column derivation in say, a COPY stage:
For example:
NQTRS between (2007-03-31 - 2008-03-31) + 1 = 5 (absolute value)

Those of you familar with SAS, the code would be
NQTRS = INTCK('QTR','31Mar2007'd,'31Mar2008'd) + 1;
and would return 5

ArndW · Post by **ArndW** » Tue May 06, 2008 6:48 am

Convert your dates to internal format, then use OCONV(In.Date1,'DQ') to get the quarter number and OCONV(In.Date1,'DY') to get the year and then (Date1Q+(Date1Y*4))-(Date2Q+(Date2Y*4))

kcbland · Post by **kcbland** » Tue May 06, 2008 7:28 am

A Time dimension would be helpful.

ray.wurlod · Post by **ray.wurlod** » Tue May 06, 2008 3:45 pm

Moderator: please move to parallel forum