Access Query Replace String

[kashif.special2005]

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

 

[bob fitz]

Set the fields Format property to Short Date