Problem with date conversion

Skip to first unread message

Antoine Beaubien

Jul 23, 2021, 2:15:23 AMJul 23
to OpenRefine
I've got English date, in French order…

But this:

doesn't work, but this does work:

Is it because I have MacOS setup in French for the Date settings of my system?

This doesn't work:

But this does…

Is there a way to specify the date’s language setting for regionalization in my conversions?


Message has been deleted

Thad Guidry

Jul 23, 2021, 7:32:56 AMJul 23
Hi Antoine,

Yes it can take an optional language tag.

We did have some failing OS X tests and some bugs and Tom graciously fixed them last year.
You can read through them:

On Fri, Jul 23, 2021 at 1:49 AM Antoine Beaubien <> wrote:
This seams to work…
"13/Jul/2021".toDate("dd/MMM/yyyy", "en")

Surprisingly… Maybe because of this Java constructor? SimpleDateFormat(String pattern, Locale locale)


You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
Reply all
Reply to author
0 new messages