General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using date with filter in view
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only