Access Query Replace String (1 Viewer)

Hi,

I am new Access I have a date column, and the data in this column is with date and hour and I want to completely remove hour part from that data.

like below is the one in the date column, and I want to remove hour part.

08.07.2017 02:00:00

after removing the hour part the data will be like below.

08.07.2017

Please help me to achieve this task.

Thanks
Kashif

Set the fields Format property to Short Date