Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts,
DayNumberOfYear Function returns 366 days though my year is 2015.
Can you please suggest to return as 365 days. Because it impacts the Annualized calculation if not leap year.
Appreciate your prompt response.
Thanks,
Sasi
To quote swuehl's respsonse in the above thread:
>>The QV function daynumberofyear() always uses years based on 366 days (leap years).
Hi Sasi ,
In Back End :
DayNumberOfYear(Date) as DayNumber,
http://www.qlikviewaddict.com/2013/03/dates-in-qlikview-part-3.html
HTH,
Hirish
Hi Sasi, as said above DayNumberOfYear() always returns 366 days. To calculate real days you can use:
=Date(CYEndDate)-YearStart(Date(CYEndDate))+1
Thanks a lot Ruben & All.