How do i say "today" when constraining DB searches

[jessefarquhar48]

This is not right is it?

[adamhholmes]

For Today you need to use 2 constrains:

Created date ≥ Current date/time: rounded down to day

and

Created date < Current date/time: rounded down to day: +(days) 1

[jessefarquhar48]

Thanks again Adam!

[jessefarquhar48]

And how do we say ‘yesterday’ is it:

Created date < Current date/time: rounded down to day: +(days) 1

?

[bcart0v]

You can do Created Date < Current Date/Time: Rounded down to Day: +(days) - 1 to subtract 1 day

[keith]

Constrain a list of items created today

As I’ve explained numerous times (in context, so these replies are admittedly hard-to-find), two dates (which are moments in time) happen on the same “day” (SORT OF) if a non-ambiguous text-wise comparison of the two dates (dropping time) is the same. For example: date_1:formatted as text (format MM/DD/YYYY for example) is date_2:formatted as text (again formatted as MM/DD/YYYY) … will be true if these dates happened on the same day… in whatever timezone the formatting happens in. It is this …

[adamhholmes]

And how do we say ‘yesterday’ is it:

Created date < Current date/time: rounded down to day: +(days) 1
?

No… that means anything with a created date before tomorrow (which will be everything, as nothing can be created in the future)…

For ‘yesterday’ you need the following 2 constraints:

Created date ≥ Current date/time: rounded down to Day: +(days) -1

Created date < Current date/time: rounded down to Day

But, as @keith points out, the concept of ‘Today’ or ‘Yesterday’ is a relative term, dependant on time zones (a single moment can occur on two different days, in different time zones), so you need to consider from who’s perspective you’re talking about when you say Today or Yesterday.