Re: How do i convert a regular date to a julian date in a query

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 10:07:45 -0600

By "Julian Date" do you mean "day of year"? If so, create a calculated field
and use the Format function or DatePart function. Format will return a
String value, DatePart will return an Integer value (both will look like
numbers, but it could make a difference if you're sorting on the field).

JulianDate: Format([Date Field], "y")
or
JulianDate: DatePart("y", [Date Field]) 

-- 
Wayne Morgan
MS Access MVP
"Andrew R" <Andrew R@discussions.microsoft.com> wrote in message 
news:9B879AC9-7147-4CE4-ABCE-7596EAF17615@microsoft.com...
>