Calculating Day no. From Start of the year

[#1]

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

[Anonymous]

PFA

Hope it helps

[Anonymous · Accepted solution]

use  DayNumberOfYear(YourDateField)

anant

[Anonymous]

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

[sureshbaabu]

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

[#6]

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

[edwinmatlapeng]

just use the function DayNumberOfYear(datecolumn).

[sureshbaabu]

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

[#9]

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..

[Shubham_Deshmukh]

what if we need it it in reverse ?
001 - 01JAN