Calculating the Number of Days Between Two Dates

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I need to calculate the number of days between a fixed
date (i.e. 09/31/92) and the present date. Can someone
tell me how? Thanks in advance for the help.
 
Use the DateDiff function.

DateDiff("d", #9/31/1992#, Date())

Of course, this has nothing to do with table design...
 
Tim Ferguson said:
Ten gets you fifty he'll be back asking how to calculate this in a
Click to expand...
table...

Do I look that stupid? <g>

(Of course, if you want to give me 50 pounds for my 10 Cdn$ wager... <g>)
 
Back
Top