DayNumberOfYear Function...

[#1]

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

[Chanty4u]

hi,

Convert Day Number of year to date

abve link helps u what u want exact..

thanks 'S

Suresh

[jonathandienst]

To quote swuehl's respsonse in the above thread:

>>The QV function daynumberofyear() always uses years based on 366 days (leap years).

[HirisH_V7]

Hi Sasi ,

In Back End :

DayNumberOfYear(Date) as DayNumber,

http://www.qlikviewaddict.com/2013/03/dates-in-qlikview-part-3.html

HTH,

Hirish

[rubenmarin]

Hi Sasi, as said above DayNumberOfYear() always returns 366 days. To calculate real days you can use:

=Date(CYEndDate)-YearStart(Date(CYEndDate))+1

[#6]

Thanks a lot Ruben & All.