Forum Discussion

NateElme's avatar
NateElme
Qrew Trainee
8 years ago

Formula Checkfield to be true if a Date field is during the previous month.

Greetings Quickbase, I'm trying to create a formula checkfield that replicates the functionality of a Quickbase report.  I would like this field to be checked if some date field is during the previ...
App builders
NateElme's avatar
NateElme
Qrew Trainee
8 years ago
That worked great!  Also, is there a way I can do this by Week to Date and/or by Previous Week?

Thanks
DanLadner1's avatar
DanLadner1
Qrew Trainee
8 years ago
You can do something like this to check for a date in the previous week:
if( [Date]>=FirstDayOfWeek(Today()-Days(7)) and [Date]<=LastDayOfWeek(Today()-Days(7)), true)