How to convert string such as "January 25, 2025 9:15 am" to a date?

tarak

I am struggling to come up with a solution to convert a timestamp string to a date. The format of the timestamp has the month spelled out as in "January 25, 2025 9:15 am."

Many thanks,

TARA

prime_nathaniel

• @tarak if you can't reformat the incoming data (which is the better way to do this).
  
  1. Find ","
  2. Find " "
  3. month is 11 If then's for month text left of the " "
  4. day column is right of the " "
  5. year is everything to the right of the comma minus the " "
  
  Recombine into one formula with date(year, month, day)

prime_nathaniel

• @tarak if you can't reformat the incoming data (which is the better way to do this).
  
  1. Find ","
  2. Find " "
  3. month is 11 If then's for month text left of the " "
  4. day column is right of the " "
  5. year is everything to the right of the comma minus the " "
  
  Recombine into one formula with date(year, month, day)

tarak

Thank you. This works. I will look into other options for potentially getting the incoming data formatted, but for now I am able to move forward. Cheers!