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

    Validate a date field

    imgaryshap

      Title

      Validate a date field

      Post

      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.

       

      -G.

       

       

        • 1. Re: Validate a date field
          philmodjunk
            

          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.