Getting a specific range of data store items

[Elias]

Aloha,
I’m trying to count the numbers of records with a specific date.

This is the data store.

Goal of the scenario is to, on Tuesday, look how many people registered on Monday and deliver that amount as a message in a Slack channel. Subsequently, deleting all the records of Monday-registrants.

I’m having a tough time trying to figure this out.

‘Search records’ doesn’t seem to return any values, even playing around with removing the ‘now’ and just entering tomorrow’s date.

When I remove any of its filters, it does return all of them, however.

Any help/advice?

All the best,
Elias

[Princy]

You have to use earlier and after both filter.

Why you are using 00:00 with now variable?? It already have time

Princy Jain
Make consultant,
For consulting support: Follow up Automated

[Msquare_Automation]

Hi @Elias

To solve your issue, please use the function and operators as shown below:

If you require additional assistance, please don’t hesitate to reach out to us.

MSquare Support | Book Live Implementation

Visit us here

Youtube Channel

[Elias]

This is how I solved it, since the scenario runs every day at 10AM.

[vendy]

Hey there @Elias

Congrats on solving this!

Thank you for sharing the approach that worked for you. This keeps our community organized and neat.