Juilan date Conversion

[dslearner]

HI,

i need the some information regarding the julian date convertion,

My input filed value:20031126(flatfile)
My Target field value(julian date):37949(sybase)
base date is 19000101.

How can i get this in datastage??????????????

Thanks
Learner

[ArndW]

If you take your base date and convert it to internal format ICONV("1900-01-01","D4-YMD") you can subtract that from the date in question ICONV(In.Date,"D4YMD") to get number of days since base. This is, I think, the date you are looking for.

Please refrain from using the word "urgent" in your posts, it will not get you an quicker responses - in fact I am sure that others read this before me and decided not to respond and I almost didn't do so as well because of that one word.

[ray.wurlod]

There are some SDK Routines for working with dates based on 1900-01-01. Check them out.

[kommven]

create a routine and in routine use this one

Ans = @NULL
If IsNull(TheDate) Then RETURN(Ans)
TheYear = TheDate[1,Len(TheDate)-3] + 1900
TheDay = TheDate[3] ;
DSJulianDate = TheYear : "" : TheDay
Ans = Oconv(Iconv(DSJulianDate, "DYJ"), "D-YMD[4,2,2]")

RETURN(Ans)