Formatting Issue (1 Viewer)

Hi,

I'm facing format issue on access,

For instance: I have a table like this (around 9 million records)

Column "F3" considered as long text as raw data itself in same format.


F1 F2 F3 F4
708807945 784440121 4/1/2017 11:36:48.000000 29
707018522 783080247 4/1/2017 17:11:16.000000 15
707920835 786517578 4/1/2017 07:37:45.000000 15

and tried this formula

SELECT FORMAT (F3, "DD/MM/YYYY") AS CALLDATE, COUNT(F1) AS TOTAL_CALLINGNUMBER, COUNT(F2) AS TOTAL_CALLEDNUMBER, SUM(F4) AS TOTAL_DURATION
FROM [Table1]
GROUP BY FORMAT (F3, "DD/MM/YYYY");

Not achieving desired output:

Still getting 4/1/2017 11:36:48.000000

kindly help me out to get 4/1/2017 format-

Thanks,

use:

Cdate(Left([F3], Instr([F3]," ")-1)) As CallDate