Your datetime search returns more records than expected

Question

I searched for all the user profiles created after September 25, 2017 (that is, September 26 or later) by using the query created > "2017-09-25". However, the returned results include users whose profiles were created on (not after) September 25. Why?

Answer

That’s because, in the Console, the datetime value 2017-09-25 is actually short for this:

2017-09-25 00:00:00.000000

Effectively, that refers to the exact instance at which the date clicked over to September 25th. Any date or time later than that (including, for example, a time one second into September 25th) is greater than your specified date.
To find all the accounts created on September 26, 2017 or later (which is what you really want), use this query instead:

created>= "2017-09-26"

That returns the data you’re looking for.

For more information on searching for datetime values in the Console, see Searching for Datetime Values.


Did this page help you?