andrewpiconnect
asked on
access 2010 vba calculate dates
Hi,
I have a query regarding using vba to calculate due dates.
Overview:
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
etc etc
Many thanks
I have a query regarding using vba to calculate due dates.
Overview:
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
etc etc
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for catching that Rey, I hate dd/mm/yy format!
ASKER