Skip to Content
0
Former Member
Jan 01, 2008 at 08:30 PM

ZFISQUARTER

23 Views

Hi Everyone,

Wish you 'A HAPPY NEW YEAR -2008'!

I am displaying values for 0FISCYEAR,0FISCPER AND 0FISPER3 using the Date field "Billed date" using the formula with the variant 'X', Whereas i have the problem in displaying the value for "ZFISQUARTER" which should be based out of this variant 'X' because the client is calculating values based on starting from 'FEB' to "JAN" Fiscal Year,

I tried with the several options using formula, only the formula available is "DATE_CALQUARTER" which qives the quarter values starting from 'Jan" onwards, Whereas i Need from "FEB" onwards say displaying

'FEB,MAR,APR - YYYYQ1 MAY,JUN,JULY YYYYQ2...

Can any one suggest me how to use the formula for this one or I need to hard coding for this,

If so help me with the Coding and where to code!

Thanks in advance,

Ram