Convert Julian date to calendar date

I am looking for the syntax to convert a Julian date to Calendar date in Crystal Reports using a calculated field or other utilities available in Crystal
LVL 3
Trygve ThayerIT DirectorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
0
 
mlmccCommented:
Does that work or what format are your julian dates in?

mlmcc
0
 
Trygve ThayerIT DirectorAuthor Commented:
I have the crystal report open but don't know the syntax to type in.
0
 
Trygve ThayerIT DirectorAuthor Commented:
I am close but I can not get the comma and the descimal gone
 
it is showing  2,010,085.00
I need it to be   0085
 

NumberVar YearOfDate := Year (DateValue ({BAQReportParameter.Option02}));
DateTimeVar LastDayLastYear := DateValue ((YearOfDate - 1), 12, 31);

NumberVar JulianDate := 0;
NumberVar JulianDateYear := 0;

JulianDate := DateValue ({BAQReportParameter.Option02}) - DateValue (LastDayLastYear);

JulianDateYear := (YearOfDate * 1000) + JulianDate;

Open in new window

0
 
mlmccCommented:
If you drop the Julian Date field on the report, what does it show?

mlmcc
0
All Courses

From novice to tech pro — start learning today.