ISO To American

That's nice, but as I noted above, I want a general solution that isn't tied to FMP only. Plus, I want to use a Date API.

The solution you included works well, but it's convoluted (not your fault) and not intuitive. A Date API fixes that problem which is important for code maintenance (code clarity).