Calculating end of moth in case month is e.g. 28, 20 or 30 days
I have employee records. In the record is a field date "Date1" This is used for the date an employee started working for a company.
The second field is a field with "Number of Months" for the temporary contracts. I calculate the end of the contract, so the HRM Manager gets an alert before the contract ends. This calculation is not the problem. The problem rises when someone is hired on e.g. August 31. If this person is hired for 6 months, the calculated field returns March 03 instead of February 28.
This is what I use in the calculated field:
Date ( Month (Date1) + Number of Months; Day ( Date1); Year ( Date1))
I can't find a solution for this, but that has (I think) a lot to do with our Dutch translations.
Can someone help me out?