Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

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
0
ALANC30
Asked:
ALANC30
  • 2
1 Solution
 
ebolekCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now