DSXchange

Posted: **Thu Jun 12, 2008 6:10 am**

Hi all,

I am facing a problem in converting a julian day to DATE.

Ex: The Julian day value I am getting from source is like 12350 (20011023). When I am using the following DatefromJulianday function in he transformer then I am getting the error like "Error n converting"

But when I try using DateFromJulianDay(DateToJulianday(CURRENTDAY)). It worked fine.

Can anybody help me in solving this issue.

Thanks.

Posted: **Thu Jun 12, 2008 7:29 am**

Hint: You only have a Julian date if

Code: Select all

DateToJulianDay(StringToDate('2001-10-23','%yyyy-%mm-%dd'))

is equal to 12350

Posted: **Tue Jul 01, 2008 9:32 am**

Hi ArndW,

Is there any function available in 7.5.1. version to similar 'DateToJulianDay' is available in DS8.0?

DSXchange

Date from Lulian day

Date from Lulian day