Calculating accruals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

grep - 09 Dec 2005 07:58 GMT

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

Reply to this Message

Klatuu - 09 Dec 2005 14:11 GMT

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)

> Given the fields:
> StartDate - the effective start date
[quoted text clipped - 8 lines]
>
> grep

Reply to this Message