Julian Calendar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a auto assign number for the ID field. My question is
that if there is a way to attach the Julian date to the assigned ID?

Thanks for your assistance in advance,

Bob
 
I'm assuming that by Julian Date you mean something like 07320 for today,
November 16, 2007, the 320th day of the year. (That's not actually the
Julian Date, but it's a common misuse of the term).


You cannot change the value assigned to an AutoNumber field, but you could
add a second field to the table, with its default as Date, so that it'll
have today's date in it.

Once you've done that, create a query that has a computed field in it to
concatenate the two fields into one, and use that query wherever you would
otherwise have used the table:

MyKey: MyAutoNumberField & Format(MyDateField, "yyy")
 
Reading between the lines, it sounds like you are going to make an AutoNumber
available for viewing by users. Basically the adage is that "AutoNumbers are
not for human consumption"! If you must then create a timestamp field for
the record and put the two values together only when you are displaying the
value.
 
Bob said:
I have a form with a auto assign number for the ID field. My question is
that if there is a way to attach the Julian date to the assigned ID?
Click to expand...


No. But, why would want to do that?

You should not cram two pieces of information into one
field. Just add a date field to the table. If you should
ever need to display the combined value to users (and I
can't see why at this point), then just concatenate the two
things together in a text box expression (or a query
calculated field):
=numberfield & Format(datefield,"yyyy") &
Format(DatePart("y", datefield),"000")
 
Doug,

Thanks for the quick response. Is there a quick or simple calculation for
figuring the Julian date?

Bob
 
It might easily depend on what you consider "the julian date"
http://en.wikipedia.org/wiki/Julian_day

If it is just the day of the year then DatePart("y",date()) should work for
you.

Bob said:
Doug,

Thanks for the quick response. Is there a quick or simple calculation for
figuring the Julian date?

Bob
I'm assuming that by Julian Date you mean something like 07320 for today,
November 16, 2007, the 320th day of the year. (That's not actually the
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
RG/Marshall,

What I am attempting to accomplish is the ID and the Julian date will be the
Record Identification number. I have a military backround and use the Julian
date more effectively than the normal calendar. I will also be using the
Julian for my search criteria. This may or may not make sense. I do
appreciate all the assistance from all who have responded to my inquiry. I
also believe your previous response and also the response from Marshall
should give me what I need to move on.

Many Thanks,

Bob
 
Back
Top