How to get Fiscal Year month from current date 1

[cmmrfrds]

What is the easiest way to derive Fiscal Year Month from the current date. Assuming Fical year starts July 1st.

So 200601 would be 200607
200607 would be 200701
etc....
Thank you.

 

[LKBrwnDBA]

Try:

SELECT TO_CHAR(ADD_MONTHS(SYSDATE,6),'YYYYMM') FROM DUAL;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[cmmrfrds]

Perfect. Thank you.

 

[SimonSellick]

Shouldn't the months added be -6?

 

[cmmrfrds]

No, I am going from calendar year/month to fiscal year/month. The calendar month is 6 months behind the fiscal month.

 

[SimonSellick]

Sorry, you did say that at the outset but I hadn't thought of a FY starting the year before. Is this an HE/FE application?

 

[cmmrfrds]

The term HE/FE is new to me. So, I guess the answer is no.