Extract date

[Michael_bn]

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

[TheTimeSavingCo]

Does this look right? 

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