Harry said:
:
How can I choose today's date as the current date to perform filters?
Harry
Harry,
You could use the Today function but as soon as the filter is applied,
that date will be hard-coded into the filter. This means that the next
time you use the filter, it will no longer be the current date.
Your best bet is to use a spare date field and customize it by setting
its value to be the Current Date. Then set your filter to test for that
spare field value.
Hope this helps.
John
Project MVP
John,
How can I customize spare data field by setting
its value to be the Current Date?
Harry
Harry,
Go to Tools/Customize/Fields. Select a DateX field and hit the "Formula"
button. In the formula entry box put [Current Date], (just like I've
shown, with the brackets), and hit "OK". Now set your filter to test for
the DateX field you customized and you should be all set.
John
Project MVP
