Re: Filtering on Date field

2009-02-20 Thread Ken Kixmoeller/fh
On Feb 20, 2009, at 8:30 AM, Tracy Pearson wrote: > According to the VFP 6 help file, it was. Thanks --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://le

Re: Filtering on Date field

2009-02-20 Thread Jean Laeremans
On Fri, Feb 20, 2009 at 3:30 PM, Ken Kixmoeller/fh wrote: > Was the DATE(y,m,d) syntax in VFP6? I thought it came with 7 or 8. Indeed it was: ldDate = DATE( [ nYear, nMonth, nDay ] A+ jml ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

RE: Filtering on Date field

2009-02-20 Thread Tracy Pearson
According to the VFP 6 help file, it was. Tracy -Original Message- From: Ken Kixmoeller/fh Sent: Friday, February 20, 2009 9:31 AM Was the DATE(y,m,d) syntax in VFP6? I thought it came with 7 or 8. On Feb 20, 2009, at 8:25 AM, Tracy Pearson wrote: > This is the format I prefer to use

Re: Filtering on Date field

2009-02-20 Thread Ken Kixmoeller/fh
Was the DATE(y,m,d) syntax in VFP6? I thought it came with 7 or 8. On Feb 20, 2009, at 8:25 AM, Tracy Pearson wrote: > This is the format I prefer to use. It avoids trouble when the > application > might have a different SET DATE which can bite you with CTOD() > > Tracy > > -Original Mess

RE: Filtering on Date field

2009-02-20 Thread Tracy Pearson
This is the format I prefer to use. It avoids trouble when the application might have a different SET DATE which can bite you with CTOD() Tracy -Original Message- From: Vince Teachout Sent: Friday, February 20, 2009 9:27 AM Ken Kixmoeller/fh wrote: > On Feb 19, 2009, at 10:13 PM, Efren P

Re: Filtering on Date field

2009-02-20 Thread Vince Teachout
Ken Kixmoeller/fh wrote: > On Feb 19, 2009, at 10:13 PM, Efren Pedroza wrote: > >> DateFiled > '01/01/2008' and I get a Type Mismath Error. As you've seen, there are several ways to skin that cat. Here's another: DateFiled > Date(2008,1,1) ___ Post

RE: Filtering on Date field

2009-02-19 Thread Efren Pedroza
Thanks !!! It works -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Sent: Thursday, February 19, 2009 10:32 PM To: profoxt...@leafe.com Subject: RE: Filtering on Date field Try DateFiled > ctod('01/01/2008

re: Filtering on Date field

2009-02-19 Thread Joe Yoder
hursday, February 19, 2009 11:13 PM, Efren Pedroza wrote: > >Date: Thu, 19 Feb 2009 22:13:20 -0600 >From: Efren Pedroza >To: profoxt...@leafe.com >cc: >Subject: Filtering on Date field > >Hi All, can some one help me on how to filter some table based on a Date >Filed ? > &

Re: Filtering on Date field

2009-02-19 Thread Ken Kixmoeller/fh
On Feb 19, 2009, at 10:13 PM, Efren Pedroza wrote: > DateFiled > '01/01/2008' and I get a Type Mismath Error. DateFiled > {^2008-01-01} Dates aren't glorified text fields in FP/VFP. Depending on your STRICTDATE settings. Look up SET STRICTDATE in Help. Ken ___

RE: Filtering on Date field

2009-02-19 Thread John
Try DateFiled > ctod('01/01/2008') John Harvey -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Efren Pedroza Sent: Thursday, February 19, 2009 10:13 PM To: profox@leafe.com; profoxt...@leafe.com Subject: Filtering on Date

Filtering on Date field

2009-02-19 Thread Efren Pedroza
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 ___ Post