Issue resolved. I was missing one change in the query and now it's working.
I put the following:
startdate: =DateAdd(DateInterval.Second, +1, DateAdd(DateInterval.Day, 0, Today()))
Result: 8/12/2016 12:00:01 AM
Enddate:
=cdate(format(now, "MMM dd, yyyy HH:mm:ss"))...