Forum Discussion

  • donaldlundgren1's avatar
    donaldlundgren1
    Qrew Trainee
    7 years ago
    Use a rich text field with something like this

    If(Today()>[DueDate],"<div style=\"font-size:10pt;color:red;font-weight:bold\">"&[DueDate]&"</div>",
    "<div style=\"font-size:10pt;color:black;font-weight:bold\">"&[DueDate]&"</div>")
    • MartinBolduc's avatar
      MartinBolduc
      Qrew Member
      5 years ago
      Hi, the above and below formula works, but I would like to add a rule so a date turns red  when past, but also stops to be red once a certain checkbox field is checked out.

      If(Today()>[Date Finish Est],"<div style=\"font-size:10pt;color:red;font-weight:bold\">"&[Date Finish Est]&"</div>",
      "<div style=\"font-size:10pt;color:black;font-weight:bold\">"&[Date Finish Est]&"</div>")

      then add something like: (((¨¨stop red if (Ready for construction) is checked¨¨)))

      And, I would like my date to show up as:
      MAR-31-2021


      Any help is welcome.

      Thanks.

      ------------------------------
      Martin Bolduc
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Here is a formula to get the date into a text format that you want. And then a change to the formula. 
        Done on an ipad so not tested.  Post back if it doesn't work. 

        var date MyDate = [Date Finish est];
        var Text DateFinishEst=
        List("-",
        Case(Month($MyDate),
        1,"JAN",
        2,"FEB",
        3,"MAR",
        4,"APR",
        5,"MAY",
        6,"JUN",
        7,"JUL",
        8,"AUG",
        9,"SEP",
        10,"OCT",
        11,"NOV",
        12,"DEC"),
        Right("0" & ToText(Day($MyDate)),2),
        ToText(Year($MyDate)));



        If(Today()>[Date Finish Est] and not [Ready for construction],



        "<div style=\"font-size:10pt;color:red;font-weight:bold\">"& $DateFinishEst &"</div>",
        "<div style=\"font-size:10pt;color:black;font-weight:bold\">" $DateFinishEst &"</div>")

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------