Or simply "Abs(Table2.date - Table1.date) <= 10"
Bill Thoen wrote:
> Have you tried selecting setting the where clause to
> "Table2.date >= (Table1.date - 10) AND Table2.date <=
> (Table1.date + 10)"
>
> Tom Manson wrote:
> > Okay people, how much do you know about Date functions in MI? Is it possible
> > to select a row from Table1 where the date is within 10 days (for example)
> > from another row in Table2? As far as I can tell, I can only select rows
> > based on month, day of the week, day or year.
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
