I had two calculated columns "Month" and "Year" that displayed forms grouped by these columns. They were calculated from the last modified column.
=TEXT(Modified,"mmmm") which worked fine until I relinked everything it now the modified dates are all the same.
Every time a form is submitted it has the date at the end of the "Title" string. They will never have the exact same character length but the date is always at the end. Here are some examples:
- Daily Report_ Aaron Stinson - Weatherford - 2015-03-11
- Daily Report_ Andrew Beck - Minot - 2015-02-03
Is there a way to use a formula to pull the month and year out of the "Title" string?
I've been playing with LEFT, RIGHT, and LEN trying to figure this out but having no luck yet.