1 Reply Latest reply on Aug 20, 2013 9:09 AM by philmodjunk

    conditional formatting - particular date range

    VietLuu

      Title

      conditional formatting - particular date range

      Post

           I have a field that tracks when somthing was submitted.  I'd like to have a box with a condtional formatting formula which fills in a particular color if the latest submitted submission date falls past 2 weeks, 3 weeks and plus 4 weeks.  Is that possible?

        • 1. Re: conditional formatting - particular date range
          philmodjunk

               I read that as a date field where the date is 14 to 20 days, 21 to 27 days or more than 28 days in the past.

               You'll need 3 conditional format expressions, one for each color/date range combination.

               Let ( T = Get ( CurrentDate ) ; T - 14 > YourTable::SubmissionDate AND T - 21 < YourTable::SubmissionDate )

               Let ( T = Get ( CurrentDate ) ; T -  21 > YourTable::SubmissionDate AND T - 28 < YourTable::SubmissionDate )

               Get ( CurrenDate ) - 28  > YourTable::SubmissionDate