Anyone familiar with JD Edwards Julian Dates

[Jovix]

I'm putting together a report which is extracting data from our JD Edwards database. The dates are in Julian format. I need to know if there is a way to convert the julian date to conventional date withing a query. for example...

If Julian date is 104092
Convert it to 04/01/04

Thanks in advance.
Jovix

 

[EBGreen]

I would try using DateAdd and adding the Julian date to as days to 4/4/1719

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[hymn]

have a look at

http://support.microsoft.com/default.aspx?scid=kb;en-us;162745

Hope this helps
Hymn

 

[EBGreen]

That is a much better way to do it.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Jovix]

Thanks for the link Hymn. I got it to work.

Jovix

 

[hymn]

Pleasure

Hope this helps
Hymn