Skip to Content
0
Former Member
May 09, 2008 at 11:07 AM

how to get current fiscal year/quarter/month/week

68 Views

Post Author: madhu.raj.india@gmail.com

CA Forum: Semantic Layer and Data Connectivity

Hi friends,

I have to calculate

1. current year/quarter/month/week.

2.Previous year/quarter/month/week.

please tell the process to achieve the above scenerio's.

the structure of the fiscal_cal is as follows.

Name Null? Type

-


-


-


TODAY NOT NULL DATE

FISCAL_DAY NUMBER(8)

FISCAL_WEEK NUMBER(6)

FISCAL_MONTH NUMBER(6)

FISCAL_QTR CHAR(18)

FISCAL_YEAR NUMBER(4)

FISCAL_MONTH_WORK_DAYS NUMBER(2)

-


sample week data is as follows

FISCAL_WEEK

-


200752

200753

209901

Thanks.