[R] Improve as.Date() error message when supplying several tryFormats

[asfimport]

We could use coalesce() to cycle through several {}formats{}. However this would not get us a behaviour identical to base R. For more on this see Jon's comment in the umbrella / parent issue. 

I improved the error message and the behaviour with remain the same. Users will not be able to supply more formats to {}tryFormats{}, but they will be advised to try the specialised parsing functions when they do so.

Reporter: Dragoș Moldovan-Grünfeld / @dragosmg
Assignee: Dragoș Moldovan-Grünfeld / @dragosmg

Related issues:

• [R] strptime should return NA (not error) with format mismatch (depends upon)

PRs and other links:

• GitHub Pull Request #13070

_{Note: This issue was originally created as ARROW-15804. Please see the migration documentation for further details.}

[asfimport]

Nicola Crane / @thisisnic:
Issue resolved by pull request 13070
#13070