Julian Date in Crystal Report Designer 1

[manikant]

Hi
I am trying to print julian date on a report by setting it as formula. Can I get help in this regards thanks in advance

 

[dgillz]

There is (or was) a JuliantoDate() UFL on the crystal decisions website that you could download. I am sure its still there if you look for it, but of course its now the business objects website.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[bdreed35]

If you are using the modern version of the Julian Date which equals the number of days from January 1st to a specified date in the same year, you can use a formula like this:

//@ConvertDate
WhilePrintingRecords;
StringVar result := "";
numberVar tempY := tonumber(Left(totext({Table.DateString},0,"",""),4));
numberVar tempD := tonumber(right(totext({Table.DateString},0,"",""),3));

result := totext(Date((tempY - 1),12,31)+ tempD,"MM/dd/yyyy");

result;

This was developed in a post last year (thread767-699385) in which the format of the field was YYYYddd. This might apply in your case, but since you haven't given that information, I can't say for sure.

~Brian

 

[manikant]

Hey dgillz,
There is a function like datetojulian but to get that function according to the information
on business objects website a dll has to downloaded and copy it to windows/system folder.
I tried as per the instructions in read me file but could not see the functions. Can some one help
me in using dlls


Thanks in advance