Get Julian Date from BRIO

axcolo · Mar 27, 2003

I have a Date field that I want to convert to Julian Date.
Has anyone done this successfully?
Thanks!

sirmanson · Mar 27, 2003

Where are you trying to convert this date? In the Query/Results or a report? What kind of database is the data coming from?

axcolo · Mar 27, 2003

In the Results. The data is from one of our DB2 tables.

sirmanson · Mar 28, 2003

You should be able to modify the query with something similar to this :

cast( year(thedate) * 1000
+ dayofyear(thedate) as char(7) )

axcolo · Mar 28, 2003

This worked just fine... thank you!