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)
  • NateElme's avatar
    NateElme
    Qrew Trainee
    8 years ago
    Perfect!  Thanks Dan for all of the help!

    Cheers,