Searching for the first day of the current month

[jamesdevonport]

Hi Everyone,

I have some logic in my app where I calculate how many emails a user has sent in the current month in order to work out their billing.

At the moment, I am just using the current date -30 days but I would really like to be calculating it from the first day of the current month.

Does anyone know how to achieve this? I want to run a search for all items created between the first day of the current month and today.

Thanks! James.

[mikeloc]

Hi there, @jamesdevonport… to get the first day of the current month, use the :rounded down to option (instead of +(days) in your screenshot) and select month for the component.

Hope this helps.

Best…
Mike

[jamesdevonport]

Thanks so much, that did the trick!

I had no idea you could use the :rounded down function on dates.

Here is the new setup for anyone else interested: