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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only