Validate a date field
I'm tracking the status of something.
i have various date fields - origin, first phase, second phase, etc...
I want to make sure that a date being entered into a date field must be after the previous date (i.e. - First Phase ≥ Origin dates), and that no date entered is after the current date.
Also - if the second phase field has no entry - then the default should always be the current date.
Anyone know what the calculation for this type of validation should be?
thanks so much.