February 1, 200718 yr Hi In one field there is a pop up calander where a date is entered. What I want to do is when this date is exceeded by 3 months some kind of wanring is displayed in a field. Anyone know how? Thanks Trevor
February 1, 200718 yr Assuming you are talking about exceeding the current date by 3 months.. Create an unstored calculation field result text, calc is: If( (Date( Month(Get(CurrentDate)) + 3 ; Day(Get(CurrentDate)) ; Year(Get(CurrentDate))) < YourDateField ; "ERROR: Date Exceeded" )
Create an account or sign in to comment