Skip to Content
Mar 16, 2015 at 11:26 PM

Date Logics



I had an requirement to display date as an report header like 9+3 (forecast and actuals) examples.

Date is an webi input prompt: user inputing 20150315

where Mon = 03 and day = 15..

Fiscal start and end date are based out of fiscal calendar derived in webi.. where start date = 3/1/15 and end date = 4/4/15

no what i would be wanted is to write an logic of Mon and Day to be compared to fiscal start and end date and derive my fiscal period which is 003/2015

if my input date is 20150228 = the report header should display 002/2015 and if

my input is 20150315 = = the report header should display 003/2015

there would be cases of start and end date differ for each fiscal calnedar and date input is dynamic now how can i arrive this to display which fiscal period in my report header

if user doesnt input anything last execution date base to derive the fiscal period by lookup up the snapshot table..




Capture.JPG (23.5 kB)