Please help in implementing a Logic, date current month for example 1 April to 1 May?

[zamadshakil]

Hi Bubblers,
But I have an issue in implementing a logic of (filtering)date.
Details:
In my software, there is a credit system like user have 2500 words credits to generate content each month. But I want to show a popup when user exceed the limit.
I wanted to filter data[ like ““Do a Search for words generated [ Created by : current user , Creation Date : (current month for example) 1 April to 1 May ??? ] each item(words):Sum < 2500 words””"
How can I express date like (current month for example 1 April to 1 May ??? ).
Please Help

[J805]

You should be able to do something like this:

Creation date > current date/time: rounded down to ‘month’ 

Creation date < current date/time: rounded down to ‘month’  + month: 1

I’m not in front of my computer at the moment. But it should be something like that.

Hope that helps.

[zamadshakil]

thank you so much for your response,
and can you tell me, how can i do in one line using range like

(if I am not wrong)

[J805]

I can’t see the rest of your screenshot so it’s hard to know how to help. Can you share more of the screen? Glad it has helped so far.

[thebubbleprojects]

Use :round down to operator. Much simpler.