NEXT BILLING DATE

[deekras]

i need to be able to figure out the next billing date. (monthly biling)

i have the effective date and i need a report to show when the next billing date is. i will be basing this on the effective date. i figured i need to figure out how months the account is active and then add that to the effective date. the datediff function is not accurate. how can i figure out ho wmany months the account is active? or is there a better way?

 

[Rich]

Function GetMonths(dteA As Date)
If Day(Date) < Day(dteA) Then
GetMonths = DateDiff("m", dteA, Date) - 1
Else
GetMonths = DateDiff("m", dteA, Date)
End If
End Function
Will return the correct months where dteA is the start date.
HTH