Add format to Anytime()

[pollytatouin]

Hi,

First of all, thank you for this incredibly useful package.

I had issues with some dates from a report returning as NA, and I traced it down to anytime() needing some additional formats in order to properly read the format used by salesforce (at least in my dataset). There is ambiguity.

I don't know if it's common to all salesforce datetime fields, but perhaps it's worth an adjustment if so ?

require(anytime)

date1 <- "07/12/2022 12:00 PM"
date2 <- "24/02/2022 12:00 PM"

anytime(date1, tz = "UTC", asUTC = T)
#> [1] "2022-07-12 UTC"
anytime(date2, tz = "UTC", asUTC = T)
#> [1] NA

addFormats("%d-%m-%Y %H:%M")
anytime(date2, tz = "UTC", asUTC = T)
#> [1] "2022-02-24 12:00:00 UTC"

^{Created on 2023-05-02 by the reprex package (v2.0.1)}