1 Reply Latest reply on Sep 8, 2009 9:43 AM by philmodjunk

    Validate a date field



      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.





        • 1. Re: Validate a date field

          Your own post appears to give the answer to your question.


          For example: set a validation ( in field options dialog in Manage Database | Fields ) for First Phase as


          First Phase Field ≥ Origin date field.


          You can create your own validation message to appear when the validation is triggered. You could also use: self ≥ Origin date field.