4 Replies Latest reply on Apr 19, 2012 9:45 AM by Bradley Menendez

    Be able to locate any rows where the date is 30 days past the approved date field

    Bradley Menendez

      Hi,

           I'm trying to create a calculated field that will tell me based on a user entered date if it is 30 days passed the date they were approved, and show those results in the report...any idea where to start? i was thinking the DateAdd function but tried basing it loosely on SQL statements but i know that wouldn't really work.

       

      Thanks for any info anyone can provide!!!!