Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Number of Days Function

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

0 Replies