如何让VBA和SQL计算结束日期?
结束日期=2015年10月26日+6个月
使用VBA函数
DateAdd ( "m", 6, yourDateVariable )
您可以使用VBA日期添加函数,也可以直接在SQL:中执行
SELECT YourDate, DateAdd("m",6,YourDate) AS YourDatePlusSixMonths FROM YourTable;
或者在VBA中:
Dim today As Date
Dim todayPlusSix As Date
today = Date
todayPlusSix = DateAdd("m", 6, today)
Debug.Print today, todayPlusSix
'2015-03-06 2015-09-06