How do I setup Julian calendar dates in Access

  • Thread starter Julian dates Access 2000
  • Start date
J

Julian dates Access 2000

I am trying to Auto number a form and use the julian dates as a primary key.
Using this to print out on forms.
 
D

Douglas J. Steele

What's your definition of Julian dates? Assuming you mean yyyyddd, where ddd
is the day of the year, you can use:

Format(Date(), "yyyy") & Right("00" & Format(Date(), "y"), 3)

For today (2004-10-01), that will return 2004275


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"Julian dates Access 2000" <Julian dates Access
[email protected]> wrote in message
news:[email protected]...
 
Top