Help with calculated field.

[jtm013]

Hello, I have what i feel should be an easily answered question, but so far I have failed to find a solution.



I have a calculated field in my table the field is called 'nextduedate'. This field is calculated by taking the value from my field 'lastcompletedate' and progressing that date by whatever interval (1 month, 6 months, annually, etc) is provided in field 'terminterval'. The problem I have is that if my lastcompletedate shows 5-5-15 and the interval is 1 month then it will calculate out to 6-5-15 in nextduedate. The reason this is a problem is that the items being measured are due by month and not a specific day. I would like the calculated field to show it due on the last day of the month.

Is this possible? If so how? Thank you in advance for your assistance.

[JoeM]

Given any Date, you can get the last day of that month like this:

DateSerial(Year([DateField]),Month([DateField])+1,0)

So you should be able to incorporate that logic into your formula.

[jtm013]

That did it thank you!