ACC: DateDiff() Function Returns Incorrect Value

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new module. Enter the following in the module's Debug window (or Immediate window in versions 1.x and 2.0), and then press ENTER:
   
   ? DateDiff("n",#12-31-100#,#12-31-9999#)
   
   Note that the returned value, 911,403,103 minutes, is truncated because the actual value exceeds 2,147,483,647.
2. Enter the following calculation, which is equivalent to the function above, and then press ENTER:
   

         x=#12-31-100#
         y=#12-31-9999#
         ? (y-x)*24*60
   						

   
   Note that the returned value, 5,206,370,400 minutes, is correct. Note that Microsoft Access uses double-precision real numbers when doing immediate calculations.