DSXchange

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

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))

A Time dimension would be helpful.