Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i want to know what is day number of specific day from start of the Year
like
for feb 1 is 32nd day of the year
Date | day no |
---|---|
feb 1 | 32 |
feb 2 | 33 |
feb 3 | 34 |
feb 4 | 35 |
feb 5 | 36 |
feb 6 | 37 |
like this ..
thanks
PFA
Hope it helps
use DayNumberOfYear(YourDateField)
anant
Moreover if you dont want to deal with rowno(),
create a chart,
take TempDate as dimension and expression as follows:
=(max(TempDate)-YearStart(max(TempDate)))+1.
It will also work
Hello,
Create a variable to define the start of the year (vYearbeginddate=1/1/2014)
in your expression use 'datecolumn-vYearbeginddate'
hope this helps
thanks
Hi ,
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
Regards,
koti reddy
just use the function DayNumberOfYear(datecolumn).
Note:
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
Thanks
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..