Filter records by month

This seems pretty basic, but for some reason I don’t see an easy solution.

I have a table with a date field, and I simply want the user to be able to select a month from a drop-down list, and see the relevant records from that month. For example, user can select “January 2024”, and the table will show only records with the date field witihn January 2024.

In the preset filters for a date fields I only see relative references to the date (“current”, “next”, etc.). I’m sure there’s something I’m missing here…

PS I know the user can create a filter and choose “after”, select January 1st, and “before” and select January 31. But I want to save him the hassle, and simply allow him to choose a month and see the results.

PPS I can create the filters myself, which I will do if there isn’t something easier.

1 Like

what do you mean by PPS? you will build a custom JS solution for this?
Care to share?

I was in need of something similar and this is what I did:

  • Create an equation variable and enter MONTHNAME({Created At}) which will pull the name to the month from the date created automatic value.

  • You should then be able to sort the records by this field

There is also a list of functions here for future reference: Tadabase Equation Functions

1 Like