using Datetime to filter the record is not the ideal way to do, because it contains time part, so the best way, truncate it to date and then apply the date filter.