Split Text won’t help you. As I mentioned, you need to use math and template columns.
Assume your date is in a column called “date”:
- Math column with the formula
Year(date)- this will give you the year - Math column with the formula
Month(date)- this will give you the month number - If you need a leading zero with the month number, then you’ll need an if-then-else column:
- if month number < 10 then 0, else blank
- Then put it together with a template column:
{pad}{month}/{year}, where:- {pad} is the output of the if-then-else column,
- {month} is the output of the second math column, and
- {year} is the output of the first math column
