Hi,
I’m combining 2 fields (1 with date, 1 with time) into one single time+date field.
Problem: when it combines the time, it switches a time that was in “pm” to “am”.
Any ideas on how to solve this?
many thanks :slightly_smiling_face:
Hi,
I need to extract the time and date from strings such as this one and add them as a separate cell in the record:
“Thu 7/06 9:00am - Vinyasa Yoga @ Millennium Park”
I’m trying this but it’s returning “-2”: MID(my_string, FIND("/",my_string), - 2)
...
Justin_Barrett:
DATETIME_PARSE(TRIM(LEFT({Class Title} & "", FIND("-", {Class Title} & "") - 1)), "ddd M/DD h:mma")
Thank you SO SO much! This worked… I’m sending you a virtual cake as a BIG thank you for your amazing help :birthday:
( ```
...
we are almost there @Justin_Barrett ! Now for some reason the “am” times are not showing up.
I’ve tried duplicating the field and adding " " to it at the source
the good news is that FIND works when I duplicate the class title field with the formula ...
Thanks, I have tried copy pasting the " - " into the formula (also tried with different “-” from different cells) but it’s still not returning the number. Could it be that FIND doesn’t work with data { inside of these parenthesis} ?
thank you @Justin_Barrett :slightly_smiling_face:
Agree, we can keep this conversation in this thread for now: Extracting date from string
You can ignore the inconsistency (it’s old data). The new data is in this specific format “Thu 7/06 9:00am - ...
