Extract date

+4

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

+31

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

Adam, Airtable Consultant - thetimesaving.company

Sign up