Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Formula for date on or before last Friday

Hello,
I need a formula for date on or before last Friday....


If([PAYROLL START DATES] on or before last Friday,
"RED",
"#FFFFE0")

thank you

------------------------------
BuildPro
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    //try this
    var date MyDate = [PAYROLL START DATES];

    var number DaysToSubtract = Case(DayOfWeek($MyDate),
    0,2,
    1,3,
    2,4,
    3,5,
    4,6,
    5,0,
    6,1);

    var date LastFriday=
    $MyDate - Days($DaysToSubtract);

    If([PAYROLL START DATES] <= $LastFriday,
    "RED",
    "#FFFFE0")




    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      What should this be? $MyDate




      ------------------------------
      BuildPro
      ------------------------------
      • BuildPro's avatar
        BuildPro
        Qrew Captain
        3 years ago
        It's not colorizing some of the dates?

        ------------------------------
        BuildPro
        ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      this is incorrect:

      this is correct

      ------------------------------
      BuildPro
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        try this vesion
        //try this
        var date MyDate = [PAYROLL START DATES];

        var number DaysToSubtract = Case(DayOfWeek($MyDate),
        0,2,
        1,3,
        2,4,
        3,5,
        4,6,
        5,7,
        6,1);

        var date LastFriday=
        $MyDate - Days($DaysToSubtract);

        If([PAYROLL START DATES] <= $LastFriday,
        "RED",
        "#FFFFE0")

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------