10 Replies Latest reply on Apr 2, 2013 7:58 AM by Omar Sh

    Comparing a data field on different dates? Need Help desperately

    Omar Sh

      I really need help in creating a calculated filed that would compare a field on different as of dates and do the follwoing:

       

      IF num of Days > 30 and number of days on (date – 1) < 30  THEN 1 ELSE 0 END.

       

      Below is an example of how it would work.  Thanks

       

      Date                      # of  Days                                Calc Field I need

       

      Mar 1                     28                                             0

      Mar 2                     29                                             0

      Mar 3                     30                                             1

      Mar 4                     31                                             0

      Mar 5                     32                                             0

      Mar 6                     28                                             0

      Mar 7                     29                                             0

      Mar 8                     30                                             1

      Mar 9                     31                                             0