How to do a search on month basis?

Hi! I have a data type message with fields creation date and text. Is it possible to do a search for number of texts that were created in current month and separate search for previous month. Thank you!

In the search constraint setup

Date (is or bigger than) current date change date to 1
Date (is or smaller than) current date change date to 31 (Or current date + 1 month change date to 1)

Not sure from the top of my head you can use an is/smaller/bigger than combination, but this is the general idea. Just play around the with date constraints as you see fit (using extract, change to, plus etc)

Then the output would be …text:count

1 Like