How can I only search for data created yesterday?

Hi forum,

I want to search “Leads” that are only created in the previous day.

How can I proceed this?


Hi there, @jona… try using these constraints.

Created Date >= Current date/time:rounded down to date +(days): -1
Created Date < Current date/time:rounded down to date


Thanks Mike, will this take the whole day from 00:00 to 00:00 the next day?


Yes, those constraints will give you the whole day for yesterday (i.e., always the day before the current day).

1 Like

Okay, nice!

And a other question,
Schermafbeelding 2023-11-29 om 18.05.00

How can I do the same thing here? So it is taking the date from yesterday.

If you are asking how to show yesterday’s date, use the current date/time +days -1.

Schermafbeelding 2023-11-29 om 18.08.19

Yes, but I want to format it at this way, and I dont see the option “+days”

You should see the +days operator before adding the formatted as operator to the expression.

1 Like

Thanks, again Mike.


1 Like

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