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?
Chuck
Today is tomorrow's yesterday.