Adding and subtracting dates from current date

[brianmcleer]

My first question is how to set a column to be the current date read by the computer.
Example: It will automatically say 5/8/2013 tomorrow without needing updating.

Question 2: How to add a number of days to the current date.
Example:
Add 7 days to the current date.


on 5/8/2013 it will read 5/15/2013, then automatically update to 5/16/2013 on 5/9.

Thank you for your help.

[June7]

In a query, create fields with expressions:

CurrentDate: Date()

CurrentDatePlus7: Date() + 7