Calculating the Number days between a specified range

[#1]

Hi,

I have a requirement wherein I need to obtain the number of days that fall between the start date of the Fiscal Year till the max of month which is selected.

For eg.if May and Jun is selected and year 2013 is selected I need to obtain the nimber of days between the start of Fiscal year to end of Jun which is 91(Apr1-Jun-30) similarly suppose if Month April is selected I must get 30 as the no of days.Please let me know how this could be done.

[sushil353]

Hi,

It s better to have a fiscal calendar for this situation.

check out this: http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

HTH

Sushil

[Anonymous]

Hi Anushree

use input boxes and convert this values into yyyy-mm-dd hh:mm and the use the below formula

Try this DayStart('1990-10-30 9:20')-DayStart('1990-09-18 9:20')

or post sample application i can help you

Regards

Harsha