Hi,

i have one file which has a date column in this format:
"1/15/17"

i have another file which has a date column in this format:
"1/15/2017 3:00:44 PM"

I want to compare these two dates............and not the "times"..........

In the example i show above the dates are the same => 1/15/17

How do i convert "1/15/2017 3:00:44 PM" to "1/15/17"