G Guest Oct 2, 2004 #1 I am trying to Auto number a form and use the julian dates as a primary key. Using this to print out on forms.
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 Oct 2, 2004 #2 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]...
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]...
