converting date to numeric

  • Thread starter Thread starter janecline
  • Start date Start date
J

janecline

how can I convert a date field to the unique sequential
numeric number the computer assigns to each day(my
understanding is the computer automatically assigns a
unique sequential number)
 
Perhaps, it is better to post follow-up questions / clarifications in your
original thread(s) where respondents have attempted to answer your question
rather than posting a new thread.

With the original thread(s) where potential respondents can see the previous
attempted answers and won't offer the same attempts.

For your info., each date value in JET / Access / VB is a number represent
the number of days prior to / since 30/12/1899 (this is day zero). Since it
is already numeric, you don't have to "convert" a date value to numeric. It
is also unique for each day (in the valid range of date values) and
sequential (today = yesterday + 1, tomorrow = today + 1).

You may like to clarify what you want in the original thread ...
 
Back
Top