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”
Thanks in advance,