I'm new to WebFocus. I was wondering if anyone out there had any code to get the current US governement fiscal year.

This is how it's done in classic asp but I need the equivalent in web focus...

Dim fy

//if the month is less than october then just get the current year
If Month(someDate) < 10 then
fy = Year(someDate)
Else
//add 1 to the current year
fy = Year(someDate) + 1
End If

This message has been edited. Last edited by: Kerry,

Assuming you want it in an amper variable:

-SET &CURRYR=EDIT(&YYMD,'9999');
-SET &CURRMO=EDIT(&YYMD,'$$$$99');
-SET &FISCALYR=IF &CURRMO LT 10 THEN &CURRYR ELSE &CURRYR + 1;

Thanks Ginny.

If you always want the Fed Fiscal Yr based on the system date, try this:

-SET &FFY=IF &DATEM LT 10 THEN &DATEYY ELSE &DATEYY+1;