Help

Searching for dates in a string that match a criteria (e.g. all dates/times that are on tomorrow)

Topic Labels: Data Dates & Timezones
136 0
cancel
Showing results for 
Search instead for 
Did you mean: 
acxp
4 - Data Explorer
4 - Data Explorer

In a lookup field of a record linked to many records, I have a large string of dates. They are in no particular order.

e.g:
2024-01-09 4:30pm, 2024-01-04 7:00pm, 2024-01-08 2:30pm, 2024-02-09 11:00am, 2024-01-12 6:00pm, 2024-01-12 1:30pm, 2024-01-09 12:30pm, 2024-01-15 5:30pm, 2024-01-12 12:00pm, 2024-01-10 12:00pm, 2024-01-16 5:30pm, 2024-01-18 12:00pm

How would I use a formula to refer to a separate date field(date only, no time), and create a new string with only dates from the large string that match the specified date?

e.g. If I specified "2024-01-09", for the data above this formula should return "2024-01-09 4:30pm, 2024-02-09 11:00am,  2024-01-09 12:30pm"

Thanks!

0 Replies 0