Extract text between two dates

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I want to extract user requests from a free text field. Before any statement there is a date/times associated with each request and response. Specifically I have the submitted time and first response time in seperate fields. 

Given the available data i was wondering if i can make a function to extract the text between those two dates/times.
Photo of G.Macri

G.Macri

  • 738 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
I may be able to help, but I will need more info. Can you upload a screenshot and perhaps give some more detail to the exact thing you are needing?

Is the free text field a text field with log edits turned on? Is it just a single text field you are wanting to sum up to a parent record? Are you wanting to simply see this info as in pulling a report or are you wanting it fed into another formula or field calculation? 

Without more info it seems like you can make a report that is filtered by whatever start and end dates/times from the records. 
(Edited)
Photo of G.Macri

G.Macri

  • 728 Points 500 badge 2x thumb
i want a field to drop all text after finding the first response date/time