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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.