DSXchange

Hi,

Can some one help me out on converting julian dates to YYYYMMDD format?

I/P dates are of format YJJJ and sample values are 8222 and 8225

Y-is the last digit of the year
JJJ-Number of the day in the year


Any help is appreciated

This is already discussed in this forum.

Refer the below link. This may helpfull to you

viewtopic.php?t=102387&highlight=julian+date

How do you know to which year the y refers? Is it 1998, 2008, 2018 or something else (for example 8 years after some arbitrary zero year)? What will it be when your job executes in 2011 if y is 8 ?

<rant>
Who writes these specifications anyway? The need for this compression went away when disks became cheap, at least ten years ago!
</rant>