converting julian Date to Database date

[Guest]

I need to know what formula to Use to Convert a Julian date - example:
"2006212" with a 4 digit year,
to a Database Date format - Example "20060823" with YYYY,MM,DD

Thanks in advance for your Help!

 

[Joseph Meehan]

I need to know what formula to Use to Convert a Julian date -
example: "2006212" with a 4 digit year,
to a Database Date format - Example "20060823" with YYYY,MM,DD

Thanks in advance for your Help!

How would January 2, 2007 show? 20070102 or 200712 ??? Is the data
now text or numeric?

 

[Guest]

The Julian Date for Jan 2, 2007 would show as "2007002" and the date format I
want to Convert it to is "20070102

 

[Guest]

And it is in Numeric Format

How would January 2, 2007 show? 20070102 or 200712 ??? Is the data
now text or numeric?

 

[Terry Kreft]

Using your example it would be something like

FORMAT(dateadd("d",mid("2006212",5),dateserial(left("2006212",4),1,0)),"yyyy
mmdd")

which comes out as 20060731..

 

[Guest]

Thanks Terry, that worked out great for me, Just what I was needing,

THanks Again!!!