I would run the 2 scripts below to make sure the Date values only point to the start of the day you are specify. Just up to the start of the day 00:00:00.
Names Default To Here( 1 );
dt = Current Data Table();
For Each Row(
:date = Date MDY(
Month( :date ),
Day( :date ),
Year( :date )
)
);
And with a slightly different approach, fix the :Time column
Names Default To Here( 1 );
dt = Current Data Table();
For Each Row(
:time = Hour( :time ) * 3600
+ Minute( :time ) * 60
+ Second( :time )
);
These 2 scripts will insure that Date has no times in the data, and the second one has no dates in :Time
Jim