Discussions

Expand all | Collapse all

Extract text between two dates

  • 1.  Extract text between two dates

    Posted 01-30-2019 12:55
    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.


  • 2.  RE: Extract text between two dates

    Posted 01-30-2019 20:16
    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. 


  • 3.  RE: Extract text between two dates

    Posted 01-31-2019 16:02
    i want a field to drop all text after finding the first response date/time