Calculating accruals

  • Thread starter Thread starter grep
  • Start date Start date
G

grep

Given the fields:
StartDate - the effective start date
PerMonth - the number of hours which accrue in a month
HoursAccrued - the number of hours accrued since StartDate

I want to be able to calculate the value of HoursAccrued, based on
StartDate and PerMonth. How do I do this? I don't want to use a +30,
+60, +90 days sort of thing, because that's not a true month.

Any suggestions?

grep
 
Not enough info in you post to know how and when you will increment a month,
but if you want to find the first day of any month you can use the DateSerial
function. This example assumes you want to find the first day of the current
month:
dmtStartDate = DateSerial(Year(Date), Month(Date), 1)
 
Back
Top