Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date CR8.5
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Miscellaneous
Thread ID:
00700730
Message ID:
00700776
Views:
11
You have the VFP BETWEEN backwards. The low test value come sint he middle, the high test value comes last.

? BETWEEN( {^1904/04/14} , {^1904/04/14} , {^1997/04/14} )

returns true. Changing the first date in your example to year 1930, for example, STILL returns false, which is definitely wrong.

Randy

>Hi all,
>
>This CR 8.5 Formula return True !!
>Date (1904, 04, 14) in Date (1997, 04, 14) to Date (1904, 04, 14)
>
>In VFP 7 this formula return false
>? BETWEEN( {^1904/04/14} , {^1997/04/14} , {^1904/04/14} )
>
>Is a this bug Cr 8.5 ?
>
>How then - I to solve this problem to turn over false?
>
>Thank you in advance for the assistance.
>
>bernhart
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform