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

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 10:21:29 -0600

"Andrew R" <Andrew R@discussions.microsoft.com> wrote:

Depends on what you mean by Julian Date.

If you mean the year and day of year, then maybe this might
be sort of like it:

        Format(datefield, "yyy") 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • Re: Fantastic May Day rant [was: Re: Chronicles of Narnia]
    ... (Julian counts as well as Andrew, ... he was a half-brother -- but I figure he still ... Final proof that I have a trivial grasshopper mind: ... Andrew" thing, ...
    (alt.usage.english)
  • Re: Cisco and ISA
    ... Julian, Phillip, thanks both of you for this interesting conversation. ... Regards, ... Andrew ...
    (microsoft.public.isa)
  • Re: Windows 2003 Pre-authentication failed
    ... Paul Bergson ... MVP - Directory Services ... "Andrew Teece" wrote in message ... Server Name: host/teeceserver.internal.teece.co.uk ...
    (microsoft.public.windows.server.security)
  • Losing friends/Luck of the draw-- Long
    ... We used to work together at a movie theater in Georgetown, Washington, D.C., ... The employee's handbook Andrew wrote for the theater contained this ... He left them there as a sort of a shrine. ... Sad and horrifying... ...
    (alt.support.stop-smoking)
  • Re: Losing friends/Luck of the draw-- Long
    ... always thought of Andrew on my birthday. ... We used to work together at a movie theater in Georgetown, Washington, D.C., ... He left them there as a sort of a shrine. ... Sad and horrifying... ...
    (alt.support.stop-smoking)