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 ..
Moreover if you dont want to deal with rowno(),
create a chart,
take TempDate as dimension and expression as follows:
It will also work
Create a variable to define the start of the year (vYearbeginddate=1/1/2014)
in your expression use 'datecolumn-vYearbeginddate'
hope this helps
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..