Set Locale per document or on a transform element

As a user in Denmark, I have set my locale to my current country.

But just had to make a transform which took a date (2024-10-03) and and needed to transform it to a written english date (3. October 2024).
If I did not change locale for the whole app, I would get (3. oktober 2024).

So it would be nice to be able to set/override locale either per Easy Data Transform document or maybe on individual transform elements. Like the DateTime Format.

@jimmyhartington
Possibly it is something that could be overridden:

  • at the document level
    or
  • for DateTime format and Num format transforms
    or
  • both

I will have a think about it.

1 Like

Same here.
Locale is set to English/Canada, supported date format is added “MMM d,yyyy” and a date like “Dec 5, 2024” still does not process.
Technically, the only issues should be with ddd, dddd, MMM and MMMM since those are language specific. So it may work to just completely ignore locale and only work with the language element.?

Apparently the English/Canadian locale expects a 3 character month with a dot on the end:

Jan.
Feb.

Dec.

It then converts fine.

canadian-date.transform (2.2 KB)

I think the best option would be for DateTime Format to default to the locale in Preferences, but to have the option to choose a different locale for Format from or Format to.

Interesting. Unfortunately I seem to be getting the datafile in US format :pensive:

Yes please.

1 Like