How to Convert Date Into Julian Date in Frame work manager

[jd]

How to Convert Date Into Julian Date in Frame work manager

[S2000]

I don't think there is an inbuild function.
I think the best way is to combine a number of datepart functions and then add them together.

For example (using pseudo sql)
year(date) *1000
+
day of year(date)

You may need to add a 10000 to that depending on whether your flavour of Julian date has the century or not.

This is from memory- apologies if I'm off by a factor of 10.. or more.

[jive]

HI ,

I took this calculation from wikipedia and after talking from one of my friend he tells me it's an accurate form of calculation. I also like the they present that, just check on wikipedia. the link is

http://en.wikipedia.org/wiki/Julian_day#Converting_Gregorian_calendar_date_to_Julian_Day_Number