Tracking Within a Certain Period
Need help with only tracking items in a certain period
contains(([Invoice (A)],current month), "6 - Project Complete (Current Month)")
Something like this ------------------------------ Nico...
Forum Discussion
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
Qrew Legend
Qrew Legendtry this (I'm assuming that ([Invoice (A)] is a date field type.
IF(FirstDayOfMonth([Invoice (A)])=FirstDayofMonth(Today()),
"6 - Project Complete (Current Month).")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
------------------------------