For those who always want a date to be current, TODAY is your solution.


Type  TODAY in a date field to make a date always appear current whenever you open your file.

Type @TODAY in the title or footer text to do the same. (No space after the @ symbol.)


If using it in the title or footer text, then the chart that is printed or published would have today's date on  your report.