SantasLittleHelper
Board Regular
- Joined
- Nov 25, 2016
- Messages
- 77
Does anybody know the best way to automatically add a date that is 6 months in the future?
e.g. I have a table with a 'Start Date' which is 01/04/16. How can I make the field 'End Date' in the same table automatically update 6 months in advance (01/10/16)?
I have seen a few things online about Update Queries but I am not sure how to do these.
e.g. I have a table with a 'Start Date' which is 01/04/16. How can I make the field 'End Date' in the same table automatically update 6 months in advance (01/10/16)?
I have seen a few things online about Update Queries but I am not sure how to do these.