Indexing character and date fields

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Indexing character and date fields

Message

From

11/02/2003 19:17:23

10/02/2003 20:25:15

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Miscellaneous

Thread ID:

00751736

Message ID:

00752100

Views:

Thanks guys for the help, the following did the job:

name+STR({^3000/01/01}-date_serv)

>Do something like this:
>
>

Name + Str({01/01/3000} - date_serv)

>
>Alan
>