Hi all,

I have a column of date with time,but I convert it to just a date format.

ie the column currently looks like the following:

Open Time
2015.10.27 20:00:43
2015.10.28 18:01:39
2015.10.28 18:02:34
2015.10.28 18:03:44
2015.10.28 18:07:03
2015.11.02 12:45:39
2015.11.02 13:40:55
2015.11.02 14:49:23
I want to have another column with just the date as follows:

Open Time			Date
2015.10.27 20:00:43		27/10/2015
2015.10.28 18:01:39		28/10/2015
2015.10.28 18:02:34		28/10/2015
2015.10.28 18:03:44		28/10/2015
2015.10.28 18:07:03		28/10/2015
2015.11.02 12:45:39		02/11/2015
2015.11.02 13:40:55		02/11/2015
2015.11.02 14:49:23		02/11/2015
What formula can I use to achieve this?

Thanks.