Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
11 months 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 R...
Gary1's avatar
Gary1
Qrew Cadet

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
11 months ago

That worked Gary! Thank you!!



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