Past date calculation

[ddinisco]

I have two fields Date_Hired and Date_PerformanceReview. I would like the Date_PerformanceReview to update to next year once the Date_Hire of the current year has passed.

 

Date_Hire = 1/3/2009 once the current date goes beyond 1/3 of the current year it would change to 1/3/2014

[comment]

Try =

Let ( [
today = Get ( CurrentDate ) ;
bDate = Date ( Month ( Date_Hire ) ; Day ( Date_Hire ) ; Year ( today ) )
] ;
Case (
today < bDate ; bDate ; Date ( Month ( Date_Hire ) ; Day ( Date_Hire ) ; Year ( today ) + 1 )
)
)

Make sure the calculation is unstored.

[ddinisco]

Thanks. This worked great!