G
Guest
I am trying to Auto number a form and use the julian dates as a primary key.
Using this to print out on forms.
Using this to print out on forms.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
(e-mail address removed)> wrote in message
news:[email protected]...
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
(e-mail address removed)> wrote in message
news:[email protected]...