Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Closest matching records
Message
From
30/08/2005 23:41:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Closest matching records
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01045374
Message ID:
01045374
Views:
63
Dear Professors

Field1 entitled date1, of table1, has following date type data

{25/02/2005}
{12/04/2005}
{22/05/2005}
{28/05/2005}
{05/06/2005}
{31/08/2005}

In text1 I enter date {25/05/2005}, This date is not in table.
Is it possible to findout TWO closet matching dates i.e

{22/05/2005} && closest smaller date
{28/05/2005} && closest bigger date

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform