access 2010 vba calculate dates
Posted on 2014-04-24
I have a query regarding using vba to calculate due dates.
i have a form where the user enters an start date for a contract. What i need to do is, after the start date has been entered, auto calculate 2 different dates based upon the month of the start date.
i.e. if the start date entered is any day in January, for example 05/01/2014, then due date to be calculated should be 01/03/2014, settlement date to be calculated should be 31/03/2014.
Start Date Due Date Settlement Date
any day in Jan 01/03/2014 31/03/2014
any day in Feb 01/04/2014 30/04/2014