Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to assign a number to date where 1st Jul is start date. So for eg, :
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
Try like this
DayNumberOfYear (EXP_REP_STATUS_DATE,7) as Daynumber
Thanks PM , It worked
Welcome