3 Replies Latest reply on Feb 1, 2009 10:19 AM by raybaudi

    Greater than and Less than in a date search

    carlz_1

      Title

      Greater than and Less than in a date search

      Post

      Hi everyone,

       

      What is the proper way to limit by date?

       

      I am using Set Field to enter a value into a field.  I want to do something like this:

      IF(date_applied > 01/01/2008 and date_applied < 06/30/2008;

      Set Field (field1=100);150)

      Endif

       

      It worked one time, now it does not.  I think my problem may be in the syntax of the date fields.

       

      thank you for your insight

       

      Carl Z.