How can I only search for data created yesterday?

[jona]

Hi forum,

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

How can I proceed this?

Thanks,

[mikeloc]

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

Best…
Mike

[jona]

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

Thanks,

[mikeloc]

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

[jona]

Okay, nice!

And a other question,

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

[mikeloc]

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

[jona]

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

[mikeloc]

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

[jona]

Thanks, again Mike.

Worked!