You are entering a character value while you need a date value like
CTOD('01/01/2008') or {01/01/2008}. I'm not sure if VFP 6. will accept
the second one. If it doesn't it will tell you that you need to use what
follows instead - {^2008-01-01}
HTH - Joe Yoder
On Thursday, February 19, 2009 11:13 PM, Efren Pedroza wrote:
>
>Date: Thu, 19 Feb 2009 22:13:20 -0600
>From: Efren Pedroza
>To: [email protected]
>cc:
>Subject: Filtering on Date field
>
>Hi All, can some one help me on how to filter some table based on a Date
>Filed ?
>
>I'm using VF 6.0 and when I go to table properties and type the filter like
>this
>
>
>DateFiled > '01/01/2008' and I get a Type Mismath Error.
>
>
>Thanks in advance
>
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
