DSXchange

Hi ,

if any body has a solution please help.

the desired format is YYYY-MM-DD

or any other format will do .

There is, unfortunately, no single definition or standard for "Julian Date". But DataStage has a function DateFromDaysSince() with which you can take the base date from your Julian and add the number of days to get a DATE value, which you can then format to your specifications. If your julian date happens to be the same as DataStages (which specifies "number of days from 4713 BCE January 1, 12:00 GMT") then you can use the builtin Julian date functions.

The i/p is a decimal (5,0) 09134.

I tried teh following code :

DateFromJulianDay(AsInteger(Field(DecimalToString(<ColumnName>,"fix_zero") ,".",1) ))

it gives teh o/p in '*' i.e. junk

Of course that will give incorrect output. In order to do ANY date work, DataStage (and you) need to know what actual date is represented by "09134" -> is it Febrary 13th, 1242 or December 1st, 2005 or some other date? Once you know that date, then you can use the DateFromDaysSince function.

Hi Can you tell what is ur input and what is the out put u want
if possible quote an example

Hi ,

The i/p is a decimal (5,0) 09134.

and I don't know the standard date representation.

I understand my limitations here .. if anybody can give a solid hint.. which after a little working on can yield a result it wil be great.

Hi ,

The i/p is a decimal (5,0) 09134.

and I don't know the standard date representation.

I understand my limitations here .. if anybody can give a solid hint.. which after a little working on can yield a result it wil be great.

Go back to your source, where the data comes from. Ask them what date that value represents. There's no way for us to know.

Could 09134 represent the 134th day of 2009? That format is also sometimes referred to as "Julian". And is easily converted.

Thanks Ray ,

will assume the representation mentioned by you and work on it.

will share the solution once I get it.

Thanks again.

If this is true you can use StringToDate() with an appropriate date format mask string.

ray.wurlod wrote:If this is true you can use StringToDate() with an appropriate date format mask string. ...

Hi Ray,

I tried using the following format :

StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)")

but am getting the warning :

Transformer_9,0: Conversion error calling conversion routine date_from_ustring data may have been lost

Regards

ray.wurlod wrote:If this is true you can use StringToDate() with an appropriate date format mask string. ...

Hi Ray,

I tried using the following format :

StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)")

but am getting the warning :

Transformer_9,0: Conversion error calling conversion routine date_from_ustring data may have been lost

Regards

And that only took you three months?!! Amazing! What else have you tried?

ray.wurlod wrote:And that only took you three months?!! Amazing! What else have you tried? ...

I actually started following this topic today.. trying to figure out what the exact date should look like from the source..