Date and timestamp values are evaluated in queries by using the executing user's time zone. In cases where the query exists in a program, it uses the program's time zone.
An executing user within the Eastern Standard Time zone and an executing user in Australia might see different results if they run the same query on the same database. For example, Click Date equals 4/10/19 run as a query in Atlanta, Georgia USA is likely to yield more results than the same query executed in Australia because at a specific time, 11 PM for example, 4/10/19 in Australia is still 4/9/19 in Atlanta, Georgia USA.
When you create or run a query, adjust your search criteria to take into account the time zones that might be crossed to retrieve the desired results. For example, expand the date criteria or include specific times.
Please sign in to leave a comment.