Dear All,

What I need is to pass a current date and get the last date of the year as julian date, i.e. in this format 731580.

(if 731580 is converted to date then it will read like 31-Dec-2003, this is just an example :))

Thanks for your help.

Praveen Motupally

How did you get 31-Dec-2003 from 731580.
This will have to be done with a UDF or Stored procedure. I do not know of a function that automatically does it.

check this links, maybe they will help.

http://www.sqlmag.com/Forums/message...2&threadid=496

http://www.sqlmag.com/Forums/message...threadid=15365




Sal

Hi Sal,

Yes this has to be done in the SP or UDF, any example will be greatly appreciated.

All the dates are stored as julian dates in out DB, I need to get all the records upto the current year end, so, for example we pass the current julian date then it has to return the last date of that year.

Regards

Praveen Motupally

What format of julian date are you using. I have done this with Java, but not with SQL Server. If you do a search on the web, you can find sample code, mostly in C, for calculating the julian date (Day Of Year). I will dig into my stuff and see if I find it.



Sal

This is the format we use 731442 to store the date, for everydate I need to find the last day of the year. like to do this in the stored procedure.

Thanks

Praveen Motupally