Good Evening,I am new to quickbase and am trying to figure out a way to set up a filter where a user selects a date and then a report will filter for their current billing period. We bill bi-monthly 1-15th and 16th-30th or 31st.
I was hoping a user could enter a billing record and chose 08/05/2021 and once they save and close the record their dashboard will have a "Current Billing Period" report so they only see the entries for the Current Billing Period whatever date it falls in, and once we get to August 16th the report will refresh with just those entries.
Is there a good way to do that?
Or a calculated date field that would some how make a string like 08-01-2021 - 08-15-2021, based on the date would be great too.