Skip to Content
0
Former Member
Sep 11, 2014 at 10:28 PM

how to derive Fiscal week from date

786 Views

Hi,

We've a requirement where we've to derive fiscal week from basic start date as show in below screenshot. Please can you give sample code how to derive this from date.

We're using BW 3.5 data flow. please give example how to declaration etc. in bw 3.5.

In this example for basic start date 13-oct -13 and week is 42. Our fiscal year starts fom July.

Attachments

Capture.PNG (11.0 kB)
Capture.PNG (17.2 kB)