Skip to main content
Question

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

  • July 7, 2023
  • 0 replies
  • 74 views
Forum|alt.badge.img+5

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
------------------------------
    This topic has been closed for replies.

    • Gary1
    • Registered
    • July 7, 2023

    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
    ------------------------------
    gary
    Terms & ConditionsAccessibility statement