Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using date with filter in view
Message
De
29/09/2001 08:33:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using date with filter in view
Divers
Thread ID:
00562229
Message ID:
00562229
Vues:
64
Hi,
I am using vfp 6. I am trying to set up wiew with filter related to date using view designer:
T0t.date >{^2001-08-11}; 11th august 2001 – my system date is dd/mm/yyyy (Australia)
When I run view it is correct. After saving view if I am trying to run it again I am getting message: “operator/operand type mismatch”. The save criteria looks like this: “{11/08/01}”.
The similar situation I experienced trying to setup queries.
Any suggestion what I am doing wrong?
Thanks in advance
Best regards
Jacek Olaf Klimaszewski
E-mail: jklimasz@bigpond.net.au
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform