Help

Re: Use Filters in Interface Designer to show records from "This Month" or "Last Month"

1055 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tim_Shrout
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

3 Replies 3
Tim_Shrout
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

Cara_Van_Meter
6 - Interface Innovator
6 - Interface Innovator

Welcome, @Tim_Shrout! It looks like the solution in this thread might be what you need in order to create a formula field you could use as the condition for your number element filter in Interface Designer.

Tim_Shrout
5 - Automation Enthusiast
5 - Automation Enthusiast

Amazing, this is exactly what I needed, thanks Cara!