This content has been marked as final. Show 5 replies
Try something like this
SELECT PRV.PER_NAME_QTR FROM W_DAY_D PRV , W_DAY_D CUR WHERE convert(char(12),PRV.DAY_DT)=convert(char(12),CUR.QUARTER_AGO_DT) AND convert(char(12),CUR.DAY_DT)=convert(char(12),getdate()-valueof(time_offset))
by using ago function can we get the previous quarter in current month
i created level based hierarchy and using the ago functin
but it gives the current quarter year ago values
my ago function is
That should work.
Just pull report as in this link.
if helps mark
just i check that doc
its not work for me
can u give that expression for previous quarters current year and previous quarters previous year
Send me you piece of rpd to my email