Assinging Number to a Date

[Anonymous]

Hi

I want to assign a number to date where 1st Jul is start date. So  for eg, :

• 1st July  = 1
• 2nd July = 2
• 3rd Jul =  3
• ...
• ...
• 30 Jun = 365

How do i do this.

I have the following script below, however, the 1st Jan = 1.

num(EXP_REP_STATUS_DATE+1)-num(makedate(year(EXP_REP_STATUS_DATE),1,1)) as DayNumber,

Kind regards,

Nayan

[prma7799 · Accepted solution]

Try like this

DayNumberOfYear (EXP_REP_STATUS_DATE,7)  as Daynumber

[Anonymous]

Thanks PM , It worked

[prma7799]

Welcome