Rehoboth Posted February 1, 2007 Posted February 1, 2007 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
Genx Posted February 1, 2007 Posted February 1, 2007 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" )
Recommended Posts
This topic is 6566 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now