date() opposite

[raffi]

hello, date() this macro when set in a criteria of a query, it removes all the dates in query which are today,
i want to apply this function but instead, only show the dates which are today and remove the rest,

in other words the opposite of date() in criteria

any help would be much appreciated thank you.

[trevor40]

try Not(Date())

[raffi]

simple yet effective, at showing managers todays movement report thx