I am working on a project where I need to create a variable that calculates a date exactly three months from a new hire’s start date. Thank you in advance
Can you clarify what you mean by "exactly three months" from a new hire's start date?
As a pathological example, consider an employee hired on November 30th, 2023. What would you expect the answer to be?
February 28th, 2024 would be exactly 90 days later.
February 29th, 2024 would be the last day of the third month since November 30th (which was also the last day of a month).
March 1st, 2024 would be the first real date after the non-existent "February 30th".
Good question. For scenarios where the exact date does not exist, I would use the next valid calendar date. In your example, that would be March 1, 2024
