I’m trying to make a dashboard the shows the number of records created last month. Not “within the last month” but in the entirety of the calendar month preceding this one. For example, I want to display only records created in December 2021, nothing from November 2021, or January 2022. I feel like I’m missing something supremely simple, but can’t find the answer. Can someone please point me in the right direction?
I tried a workaround by creating 2 Formula Fields in my Base calculating Current Month, Month Submitted. These fields give me integer values (ie 12 for December, 1 for January) but not the option to format as dates. Then when setting up a Filter in Interface Designer there’s no way that I can see to compare the two fields. I can set the condition to be compared to a certain exact number, but not another field. Again, unless I’m missing something obvious?