Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Extract date

Topic Labels: Dates & Timezones Formulas
321 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_bn
4 - Data Explorer
4 - Data Explorer

Hi,

I am trying to extract text and date from subject field in gmail into two seperate fields but I can not get the formula right.

The subject will be in this format  "16610 6/9"

16610 should be extracted as text into seperate field and 6/9 into date field (september 9)

Can anyone help?

/Michael

 

 

 

 

 

1 Reply 1

Does this look right? 

Screenshot 2024-09-03 at 8.30.12 PM.png

DATETIME_PARSE(
  SUBSTITUTE(
    Name,
    Text & " ", 
    ""
  ) & "/" & YEAR(CREATED_TIME()),
  "DD/MM/YYYY"
)

We need a year value so I ran with the assumption that you'd want the year that the item was created on

Link to base