Builds a set of possible format strings suitable for as.Date() for a
given day/month/year order. This is intended for fast "detect once per sheet,
then parse all" workflows.
Details
The returned formats cover common separators ("/", "-", ".", " "),
unseparated dates with numeric months, and an optional comma before a final
4- or 2-digit year element (%y, %Y) in space-separated dates.
Month handling depends on order:
If
orderuses"m", month tokens include numeric months (%m) and abbreviated month names (%b).If
orderuses"M", month tokens include full month names (%B).
Month name formats (%b, %B) are locale-dependent.
