Discussion Board for collaboration related to QlikView App Development.
i want to know what is day number of specific day from start of the Year
for feb 1 is 32nd day of the year
like this ..
Use this function DayNumberOfYear(Date) ..
Then U will Get day No for Particular date .. Easily..
If U Want day no According to fiscal year then U need to provide Off set To the Function Like this
--> DayNumberOfYear(Date , 4) or DayNumberOfYear(Date , starting month of Year)
Hope It Helps
The results after using DayNumberOfYear(Date) for the current year(2014) is perfect.
but make sure incase if you use this function for date values for multiple year.. because it returns 3 for both 01/03/2014 , 01/03/2013
Yeah Suresh ,
It Will return like That Only ..
If U want it to according to Ur database dates .. Create a master Calendar and U can put Rowno() as Dayno .
Then It Will count days from beginning Year .. If U want..