My pleasure. I need both state and month transformations in my own work and find this very helpful.
Good point. But I did that for a couple of reasons.
The first is that it's my working macro, not a version made for sharing.
The second is that it uses a function key (and modifiers) as a trigger, so I want to restrict it to text editing applications to avoid function key conflicts.
My convention is to use some function keys globally but keep other specific to applications.
F1 in any application, for example, will display a palette of macros for that application. So
F1 provides the same function in every application but is also quite different in every application.
By restricting this macro to text editing applications,
F2 is free to use in non-text editing applications.
You're right that if you use a text editing application not on my list, you may be wondering why this macro doesn't work. But I felt it was more important to restrict its scope. Of course it isn't possible to include all possible text-editing applications (because I don't have all of them) but its easy to include any that aren't in the list.
Which, BTW, is not quite as restrictive as it looks. It works in InDesign 2020, although that version isn't listed.