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

 

[james_lankford]

dim s as string 
dim s2 as string 

s = "08.07.2017 02:00:00"

s2 = left( s, 10 )  

debug.print s2

 

[alansidman]

If the field is in DATE format and not string, then in an update query you can apply the INT function which will return only the integer portion of the Date. Dates in Access are stored as numbers beginning with Jan 1, 1900. The time in a field is the decimal portion of that number while the date is the integer portion.

 

[Micron]

If this is a table, why not just format the field to short date? No code or functions needed.