>This may have been discuss before. I wonder why FP looks at EMPTY(m.date) as m.date < DATE()? The following is what I have to use (as always back with FPW):
>
>(auth.end > DATE() OR EMPTY(auth.end))
>
>I mean, to me, looking at an empty date would mean future, yet FP looks at it backwards?
Huh? If I do the following and the command window:
dDate = {} && empty date
? dDate < date()
returns True. Empty date is like time zero in the past and is not a null value [isnull(dDate) returns false]. I do not understand the problem.
Mark McCasland
Midlothian, TX USA