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