Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using date with filter in view
Message
From
29/09/2001 08:33:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using date with filter in view
Miscellaneous
Thread ID:
00562229
Message ID:
00562229
Views:
63
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
Next
Reply
Map
View

Click here to load this message in the networking platform