Date from Lulian day

[Sravani]

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.

[ArndW]

Hint: You only have a Julian date if

Code: Select all

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

is equal to 12350

[scorpion]

Hi ArndW,

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