Tracking Within a Certain Period

Question

Need help with only tracking items in a certain period
contains(([Invoice (A)],current month), "6 - Project Complete (Current Month)")
Something like this------------------------------Nicole Cabral------------------------------

markshnier__you · Answer

Can you say in English what you are trying to accomplish? You posted a partial formula but I don't understand the question.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

nicolecabral · Answer

I have a summary table and I want to see the projects invoiced within the current month. I need a formula that will allow the projects invoiced within the current month to be labeled as, "6 - Project Complete (Current Month)." Hopefully this makes sense. Kind of hard to explain.

------------------------------
Nicole Cabral
------------------------------

markshnier__you · Answer

try this (I'm assuming that ([Invoice (A)] is a date field type.
IF(FirstDayOfMonth([Invoice (A)])=FirstDayofMonth(Today()),&nbsp;
&nbsp; "6 - Project Complete (Current Month).")------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

nicolecabral · Answer

It worked! So it used the first day of the month that relates to the field in Invoice (A) and today as reference? What a weird way to get to the current month, but it worked!------------------------------Nicole Cabral------------------------------

Forum Discussion

Tracking Within a Certain Period