How to retrieve last month's records by comparing creation date to current date/time

Need help
1

Hello Bubblers,

I have been trying to write an expression to just return the count of items created a month ago by comparing it to the current date/time but it’s not returning the correct result to me.

Can someone please show me how to retrieve records created last month? Let’s assume we created those records in April and now in May, we want to get only records for April.

Thanks guys.

1 Like
2

Created date ≥ current date/time rounded down to month +(months) -1

Created date < current date/time rounded down to month

3 Likes
3

Hey @adamhholmes,

Thanks that helped but what if I want to do this within the “:filtered” function as I want to for each user. I don’t get that “:rounded down to months” option. Maybe I’m doing something wrong. :man_shrugging:t4:
ff

Thanks

4

I don’t understand…

Why would you use an advanced filter for that? (That’s just a basic constraint)

1 Like
5

Hmm… That’s a good question.

I guess I’m getting things mixed up…

Does “:round down to a month” return just one month?

6

Yep… I was wrong…

Thanks for the solution, @adamhholmes :handshake:🏼

7

This topic was automatically closed after 70 days. New replies are no longer allowed.