Date field with only day and month
I have a table with the names of employees and the date their performance appraisal is due. Since they're due annually, I'd like the date to read just the month and day. Is this possible? And then cre...
Forum Discussion
Here is a formula which presumes that you also want to allow for a review date Anniversary different from the hire date.
var date HireDate = If(not IsNull([Hire Date Override for Anniversary & Vacation]),[Hire Date Override for Anniversary & Vacation],
[Hire Date]);
var date AnniversaryThisYear = Date(Year(Today()), Month($HireDate), Day($HireDate));
IF($AnniversaryThisYear < Today(), AjdustYear($AnniversaryThisYear,1), $AnniversaryThisYear)
The effect of the formula should be to provide the next Anniversary date so if the Anniversary has just passed, then it jumps a year ahead. Feel free to post back if there are any syntax errors you can't solve.
var date HireDate = If(not IsNull([Hire Date Override for Anniversary & Vacation]),[Hire Date Override for Anniversary & Vacation],
[Hire Date]);
var date AnniversaryThisYear = Date(Year(Today()), Month($HireDate), Day($HireDate));
IF($AnniversaryThisYear < Today(), AjdustYear($AnniversaryThisYear,1), $AnniversaryThisYear)
The effect of the formula should be to provide the next Anniversary date so if the Anniversary has just passed, then it jumps a year ahead. Feel free to post back if there are any syntax errors you can't solve.