Skip to main content
Topics#Data ManagementKim Roberts의 질문
Kim Roberts (PrismHR) 님이 #Data Management에 질문했습니다
2020년 10월 7일 오후 8:42

Extract date and number from text field

I need some assistance figuring out 2 formula fields.  From the Case Subject field (text), we will have the Training Course Name (varies in length), date and duration.

 

It will look something like this: 

 

Training Course, 2020-10-15: 1 hour

 

I need a field to pull just the Date, and another to pull just the number of hours.

 

Seems like it should have been easy enough with Right or Mid, but nothing is working for me.  

 

Thanks in advance!
답변 6개
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2020년 10월 8일 오전 12:22
    Will the format always be exactly like that?  Or can the YYYY-MM-DD Date value appear anywhere in the Subject field?  
답변을 작성하세요...
0/9000