The Date Field

[merc500sl]

I am using Visual FoxPro 3.0 and 5.0 but there seems to be a problem with my date fields. When I do a comparison with two date fields (both 2000), it give me the wrong output.<br>
<br>
Could there be a problem with the way I am defining the date fields? Please help me out...

 

[dgrewe]

Visual 3.0 did/does have a error in the date field. The problem will migrate to V5.0 if the database(s) were created in V3.0. The problem stems from the Set Century on command. If one date is saved with set century off and another date is saved with set century on and the dates will not compair correctly.<br>
<br>
Try this. <br>
set century on<br>
use Database<br>
replace all date_field with date_field<br>
(do this for each date field you have in the database)<br>
then do the date compair and see if it works correctly.<br>
<br>