Odd thing happened today - working on a regular query that is sitting on a 2015-2016 table. Query normally brings back all "NEW" alerts for a given month and this month I realized that it was not including the last 19 records since the dates time stamps were on 11/30/2016 but after midnight. This was the first time that I came across this as those dates are never on the last day of the month.
Query is set up with a clause: Between [Enter start date in date format 'mm/dd/yyyy':] And [Enter end date in date format 'mm/dd/yyyy':] and the input dates for this month were 11/1/2016 to 11/30/2016.
Has anyone dealt with something similar and knows a quick solution to change the query to recognize the records with timestamps for 11/30/2016? (illustration below)
P.S. I also tested the query by manually changing the time to 11/30/2016 00:00:00
ORIGINAL_ACTION_TYPE ALERT_CREATION_TIMESTAMP ALERT_SCORE SCENARIO_ABBREVIATION FOCAL_ENTITY_TYPE New 11/15/2016 17:34 875 User ACCOUNT New 11/30/2016 15:36 875 User ACCOUNT New 11/30/2016 15:40 875 User ACCOUNT New 11/30/2016 15:42 875 User ACCOUNT New 11/30/2016 15:44 875 User ACCOUNT New 11/30/2016 15:45 875 User ACCOUNT New 11/30/2016 15:46 875 User ACCOUNT New 11/30/2016 15:47 875 User ACCOUNT New 11/30/2016 15:48 875 User ACCOUNT New 11/30/2016 15:49 875 User ACCOUNT New 11/30/2016 15:50 875 User ACCOUNT New 11/30/2016 15:50 875 User ACCOUNT New 11/30/2016 15:52 875 User ACCOUNT New 11/30/2016 15:53 875 User ACCOUNT New 11/30/2016 15:54 875 User ACCOUNT New 11/30/2016 15:55 875 User ACCOUNT New 11/30/2016 15:56 875 User ACCOUNT New 11/30/2016 15:57 875 User ACCOUNT New 11/30/2016 15:58 875 User ACCOUNT New 11/30/2016 15:59 875 User ACCOUNT