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
Solved! Go to Solution.
DATE([Loading Date / Time])
Hi @Chris_Jeal,
Does it help to have the following expression in your VC
DATE(LEFT([Loading Date / Time],FIND(" ",[Loading Date / Time])))
VC is presumed to be of date type column.
INDEX(LIST(โSunโ, โMonโ, โTueโ, โWedโ, โThuโ, โFriโ, โSatโ), WEEKDAY(DATE(LEFT([Loading Date / Time],FIND(" ",[Loading Date / Time])))))
Without checking, assuming Suvruttโs code works perfectly, adding on to the weekday and index functions should get it to the โMonโ display that you are looking for.
Edit, sorry, I misread. @Steve below put all that is needed. I thought you wanted it to say โMonโ.
DATE([Loading Date / Time]) will parse just the date part out. Similarly, TIME([Loading Date / Time]) will parse out just the time if you ever need it.
DATE([Loading Date / Time])
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |