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

Question

Greetings Quickbase,I'm trying to create a formula checkfield that replicates the functionality of a Quickbase report.&nbsp; I would like this field to be checked if some date field is during the previous month.For example(the date of this posting is 11/21/2017):&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * Formula CheckBox Field&nbsp; |&nbsp; &nbsp; Date FieldRecord 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Checked&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/10/2017Record 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unchecked&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/03/2017Record 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unchecked&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/15/2017Any suggestions or work arounds would be much appreciated!Thanks,Nate

danladner1 · Answer

If(  FirstDayOfMonth([date])=FirstDayOfMonth(AdjustMonth(Today(), -1)),  true  )

nateelme · Answer

That worked great!&nbsp; Also, is there a way I can do this by Week to Date and/or by Previous Week?Thanks

danladner1 · Answer

You can do something like this to check for a date in the previous week:if( [Date]&gt;=FirstDayOfWeek(Today()-Days(7)) and [Date]&lt;=LastDayOfWeek(Today()-Days(7)), true)

nateelme · Answer

Perfect!&nbsp; Thanks Dan for all of the help!Cheers,

Forum Discussion

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

Related Content

Previous and Next Record Buttons

A way to look up a previous Record ID's [Date Created] Field

Delete Formula Button Error

Percent Formula Help

Formula Assistance