DSXchange

What would be the best way to convert a date in format yyddd (mainframe julian)?

Thanks

Have you tried searching the pdf documentation for 'julian'? That's where I would start in your shoes.

You also need a business rule (CENTURYPIVOT) that defines how to handle two-digit years.

If the volumes are not large, a BASIC Transformer stage can do this easily. But what format does your target need to be? Here is one example (for a BASIC Transformer stage) that generates an ISO 8601 format date (YYYY-MM-DD).