Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Hubert, North Carolina, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Julian Date Question (2000 SR1)

    I have a question with properly formatting a julian date in the military format, i.e.

    Microsoft template Julian date: 03001 = 1 Oct 2003
    Military Julian date: 3001 = 1 Oct 2003

    Thanks Rob

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Julian Date Question (2000 SR1)

    Can you explain for the non-military what the relationship between 3001 and 1 Oct 2003 is, and what is input and what you want as output?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Julian Date Question (2000 SR1)

    FWIW: The MSKB has a pretty good article on the subject of Julian dates (number http://support.microsoft.com/default.aspx?...kb;en-us;209922 ). The article shows you how to write code for converting Julian to normal and vice-versa. If you haven't already read this article, you might be interested in its discussion of formal vs. informal Julian dates (you're using an informal) and the discussion of why the four-digit Julian date is not always a good choice. I have a military background myself, and I know the U.S. military typically uses a four-digit version. I suppose the Army and Navy assume the user knows which decade and century we're living in, so...why bother with a fourth digit? Hope this helps a little, Corpsman.

  4. #4
    New Lounger
    Join Date
    Jun 2003
    Location
    Hubert, North Carolina, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Julian Date Question (2000 SR1)

    The relationship between the dates used in the military format of the julian date is a one digit numeric year followed by a three digit day of the year. It is really only valid for 10 years, however it fits easily within the other programs that we use. Hope this helps.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Julian Date Question (2000 SR1)

    In your original post, you stated 3001 = 1 Oct 2003. So the 3 in 3001 is the year. But how does 001 connect with the first of October?

  6. #6
    New Lounger
    Join Date
    Jun 2003
    Location
    Hubert, North Carolina, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Julian Date Question (2000 SR1)

    Lucas,

    This is a great help however i am not entally making the leap to use a one digit year instead of the defaulted 2 year, any ideas?

    Rob

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Julian Date Question (2000 SR1)

    Sorry, Rob, but maybe I don't follow exactly what you're trying to do. Can you share a few details to show exactly how you're going to use this bit of information. By the way, I spent 27 years in the U.S. Army, and I understand the military's concept of a Julian date (the four-digit variety); but I rarely worked with such dates. What is your understanding of the five-digit version? Where did you find the Microsoft discussion of 5-digit Julian dates? In Access Help? The Microsoft web site?

    By the way, I stumbled across a really handy Julian calendar on the University of Rochester (NY) web site (http://www.dcs.rochester.edu/CALENDA..._jcalendar.htm ).

    One more thing: the Julian date for 1 Oct 03 would be 3274...right? (See Hans's question above.)

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Julian Date Question (2000 SR1)

    Based on Lucas' remarks, I would say that the following expressions do what you want:

    Right(Year([MyDate]), 1) & Format(Format([MyDate], "y"), "000")
    or
    (Year([MyDate]) Mod 10) & Format(Format([MyDate], "y"), "000")

    where MyDate is a date/time field or control.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •