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) ...