Re: Re: Re: Calculating Days

Posted by Jean Claude Servaye on September 19, 2000 at 17:49:28:

In Reply to: Re: Re: Calculating Days posted by Spike on September 18, 2000 at 22:38:16:

: : : 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.

: But How do I Read the Integer?
: I can substract 2 Date fields, but i can only read the difference in a sting.

Trunc(DateFromField - Date)

Related Articles and Replies: