Julian to Gregorian

[solmskid]

VER: Crystal XI
DB: SQL Server

Situation: Field contains contains julian day, just need to convert gregorian.

Thanks for any help.

 

[lbass]

You need to show some samples of the current value of the field and the date it should translate to. Can we assume the field is of number datatype?

-LB

 

[solmskid]

Thanks for the reply -LB

I found out after the post that we are dealing with current year data only. The field (FLDA) in question contains a numeric value that represents the julian day of the current year.
I improvised and ended up with a workable solution:
ConvDate = (Date(2007,01,01) + FLDA) - 1.