Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago

Looking for formula checkbox to check if a record was created in the first 5 days of the current month

I need to figure out a checkbox formula to check if a record was created within the first 5 days of the current month using [Date Created]. Any suggestions?



------------------------------
Dawn Rene
------------------------------

2 Replies

  • Gary1's avatar
    Gary1
    Qrew Assistant Captain
    3 years ago

    This should do the trick:

    var date created = ToDate([Date Created]);
    var date firstday = Date(Year(Today()),Month(Today()), 1 );
    var date fifthday = Date(Year(Today()),Month(Today()), 5 );
    $created >= $firstday and $created <= $fifthday


    ------------------------------
    gary
    ------------------------------
    • DawnRene3's avatar
      DawnRene3
      Qrew Trainee
      3 years ago

      That worked Gary! Thank you!!



      ------------------------------
      Dawn Rene
      ------------------------------