Simple as SPLIT() with , " "?

[Chris_Jeal]

Hi,

I have a date time field ([Loading Date / Time]) which pre-populated into my g.sheet from another source (copy and paste).

The text within the field look like this: “09.09.2019 02:00”
I am trying to split the data where there is a space which is inbetween the date: “09.09.2019” and the time “02:00”.

One VC is my goal which will show “09.09.2019” but I am struggling with this one.

How would I write the logic?
I have tried the below but cannot get the outcome I am hoping for.

index(split([Loading Date / Time]," "),1) the answer that returns from this is: “Mon”

Any suggestions?
Thanks in advance,
Chris