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.