convert date to Julian date in CR 9.0

How can I convert a date to the Julian date in CR9.0?  I do not see a CR function for this.

Thank you
ALANC30Asked:
Who is Participating?
 
ebolekConnect With a Mentor Commented:
check this link out. It will solve you problem

http://support.businessobjects.com/library/kbase/articles/c2009191.asp

Regards
Emre
0
 
frodomanCommented:
Emre's link is a good one.  One format of julian date that isn't covered there though.  If you want:

2004128 (Year / Day Number) then use this formula:

DatePart('yyyy',{table.datefield}) * 1000 + DatePart('y',{table.datefield})

frodoman
0
 
ebolekCommented:
glad to help

Emre
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.