This post is related to my post of yesterday regarding Record Selections not working. I've done some more investigation and it seems to be related to date issues betwwen FoxPro and the newer CR.
In the very old version of CR this worked, but CR 2008 seems to be handling dates in some other manner.
The record selection formula is {timesheet.date} in LastFullMonth. In 2008 it returns no records.
Eliminating the formula returns all records and the dates arb valid dates.
Changing the formula to {timesheet.date} < CurrentDate returns all the records, but the dates in descending order start at a date in 1899.
In the very old version of CR this worked, but CR 2008 seems to be handling dates in some other manner.
The record selection formula is {timesheet.date} in LastFullMonth. In 2008 it returns no records.
Eliminating the formula returns all records and the dates arb valid dates.
Changing the formula to {timesheet.date} < CurrentDate returns all the records, but the dates in descending order start at a date in 1899.