Need to convert Julian Day to Gregorian date

[rusty11]

I have a table that has a year field and day field. I only need to convert
the day field which is a Julian date to Gregorian. If possible in a query. If
not then in a module, but, I'm real rusty with access so please give explicit
instructions. I have found some codes but have not been able to make them
work with the table, I'm sure its me.

Thanks for any help you can provide me with.

 

[Wayne-I-M]

There are loads of examples out there. The simplist one I could find that
works is

SELECT DatePart("y",[TableName]![FieldName])+(Year(Now())-1900)*1000 AS
NewDate
FROM TableName;

 

[KARL DEWEY]

I only need to convert the day field which is a Julian date to Gregorian.
Your wording does not match. A 'Julian date' implies some format of year
and numerical day count within that year.
There are many such formats like --
8059 which is the 59th day of 2008.
OR
08059
What is the DataType of the fields - text or number?

 

[Ron2006]

Some examples of what you want to convert would help.

 

[Rusty]

both the day field in question is in number format.

 

[Rusty]

Here is a part of the table I'm working with.

YR DAY TIME DIC RIC CIIC FSC
2005 275 XXXXXXX A41 XXX X XXXX
2005 275 XXXXXXX A4A XXX X XXXX
2005 275 XXXXXXX A41 XXX X XXXX
2005 275 XXXXXXX A4A XXX X XXXX
2005 275 XXXXXXX A4A XXX X XXXX

 

[Rusty11]

I tried this and for 22 as in the day field I got a return of 108022. What I
was expecting back was for a Julian day of 22 a return month and day like
0122 or Jan 22, or some formonth and day. Sorry, I should have mentioned this
in my first post.

There are loads of examples out there. The simplist one I could find that
works is

SELECT DatePart("y",[TableName]![FieldName])+(Year(Now())-1900)*1000 AS
NewDate
FROM TableName;


--
Wayne
Manchester, England.

I have a table that has a year field and day field. I only need to convert
the day field which is a Julian date to Gregorian. If possible in a query. If
not then in a module, but, I'm real rusty with access so please give explicit
instructions. I have found some codes but have not been able to make them
work with the table, I'm sure its me.

Thanks for any help you can provide me with.

 

[KARL DEWEY]

Try this --
CVDate("1/1/" & [YR])-1+[DAY]

 

[John W. Vinson]

Try this --
CVDate("1/1/" & [YR])-1+[DAY]

or (almost equivilantly) DateSerial([Yr], 1, [DAY])