The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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
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
Link to base