Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on descending dates as part of expression
Message
From
24/08/2001 16:23:15
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, United States
 
 
To
24/08/2001 10:47:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00548638
Message ID:
00548971
Views:
11
Hi,

In a similar situation I discovered that VFP 6 (SP5) gave me an error if I tried to include a date constant, {^2500,1,1}, and had to substitute the date() function, date( 2500,1,1 ). I believe this issue has been fixed in VFP 7.

BTW, if your date substraction integer is within the range of the bintoc() function you might consider trying something like:

... + bintoc( date(2500,1,1) - Eff_Date )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform