changing the year start day

[rsx]

Hello,

Is there away to change the date to start April 01, instead of Jan 1?

I need to calculate which week any particular day of the year would be. So April 01 - April 08 would be week 1 and so on.

Can the DATEPART function be used some how?

Thanks in advance.

 

[gmmastros]

I don't think you can set anything to change the first day.

I recommend you create a permanent table in your database. This table should have 2 fields, a Date Field and a Week Number field. Then, instead of using the DatePart function to return the week number, you simply join to this new table and return the week number column.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mmerlinn]

I don't know how to do it in your environment.

However, you might want to look at

http://www.tek-tips.com/faqs.cfm?fid=6340

and see if you could modify it to work for you.





mmerlinn

"Political correctness is the BADGE of a COWARD!"