>Hi,
>Is anyone having problems with the DATE() function returning dates in the future ?
It is well known that all version of Fox, starting with FoxPlus in 1988 and on, have the Y10K bug - dbfs are incapable of storing dates beyond year 9999; datetimes could store that but VFP can't show those dates and reports them as blank:
x=DATE(9999,12,31)
?x
x = x + 1
?x
but
?x-34
still returns a valid date, which means a variable can hold a date after 31-dec-9999 but it can't be displayed directly - you would have to roll your own.
CREATE CURSOR uu (t t)
x=DATEtime(9999,12,31, 23,22)
INSERT INTO uu VALUES (x)
INSERT INTO uu VALUES (x+2300)
BROWSE
go bott
?t-33
Last line displays a blank, which means VFP actually refuses to store such variables into datetime fields.
That's a bug, and I don't expect it will be fixed, ever. If it does, it will be at the last minute, not our problem.