Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird set filter to date
Message
From
20/11/2003 11:42:36
 
 
To
20/11/2003 02:50:58
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00851737
Message ID:
00851924
Views:
8
>i have table dtr with field swipedate as date. then i have this,
>
>
>sdate={^2003/08/01}
>edate={^2003/08/31}
>use dtr
>set filter to between(swipedate,sdate,edate)
>locate
>
>
>even if there are dates in between the sdate and edate, locate results to none.
>
>what could be wrong?

do you have columns named sdate and/or edate?
if so, vfp will use those. to use your variables, use m.sdate and m.edate instead.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform