Number of Days Function

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Dear ALL,

I am facing a problem related to Number of Days YTD

Below are the variables that I am using in my script, my concern is the to find the elapsed time YTD.

Let vToday = num(Date('03/31/2018'));

Let vTimeElapsed =(((DayNumberOfYear('$(vToday)')))/365*100);

NOT That the issue is that DayNumberOfYear('$(vToday)') return 91 it should return 90 since in JANUARY 2018 we have 31 days , In February we have 28 days and in March we have 31 so Total number of days YTD should be equal to 31+28+31 = 90

Hope you can help

Thank you in advance

topic Number of Days Function in QlikView

Number of Days Function