Solved

convert date to Julian date in CR 9.0

Posted on 2004-08-17
3
655 Views
Last Modified: 2008-01-09
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
Comment
Question by:ALANC30
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
ebolek earned 50 total points
ID: 11823167
check this link out. It will solve you problem

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

Regards
Emre
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11823641
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
 
LVL 10

Expert Comment

by:ebolek
ID: 11823690
glad to help

Emre
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question