Restricting data based on fiscal week

[Former Member]

Hi Team,

I have a calculation view based on sql which is source for reporting tool.In the calculation view I have to restrict data based on fiscal week.

the scenario is

1) data should be displayed for 12 fiscal weeks.

past 10 weeks and future 2 weeks based on current fiscal week.

How can we put this in where clause.

Regards,

Venkat

[former_member182302]

Hi Venkat,

Is there any custom calendar you are following or the normal calendar? if it is later then the current date should be fine for you right?

To frame the END DATE :

add_days(now(),14)

To frame the FROM_DATE:

add_days(now(),-170)

And you can keep this filter condition in your script

Regards,

Krishna Tangudu