Re: Calculating Days

Posted by Jean Claude Servaye on September 17, 2000 at 23:17:32:

In Reply to: Calculating Days posted by Spike on September 16, 2000 at 16:40:52:

: Hi, I need a code for calculating dates from a table.
: I want to Substract a Date Field(From Table1) from the current date, so I can see how many days old the oldest record is.

Just substract Current date from then date field.
The integer part of the result is the number of days.