Hello. I have dates with 1/1/2016 12:30:00 PM for example. I wanted to match them to dates (1/1/2016) but the dates don't match because the minutes don't match (I believe that's why they don't match). How can I delete the minutes off?

ALSO, this format is already in powerpivot. Can I change it in there (I don't think changing just the format will work). Thanks.