Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 03, 2024 02:22 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 03, 2024 05:31 AM
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
