Date Formater - German language
Status: Open · Asked by Rudolf Adlmanninger on · 0 views
Hi,
I extract a date with the Email Parser and get it in German language, something like this: 14. Oktober 2023
Now I want to format it, using the Date/Time Formatter.
I switched on Map and set the From Format to DD. MMMM YYYY
My problem is, that for following month I get an error "Invalid Date":
März - German for March
Mai - German for May
Oktober - German for October
Dezember - German for December
This months (in German language) seem to work:
Januar
Februar
Juni
Juli
And this months are written same in German and English language, anyway.
April
August
September
November
And than I habe a special issue, as I am from Austria. :-)
Here we use (in Austrian German) Jänner instead of Januar
For one I could use the replace text step. But how can I add the value to the date/time formatter, if I have 4 Steps to replace the text for each month?
Many thanks!
Best regards,
Rudolf
Hi @rudi,
You can use the Lookup Table feature to assign specific names to each month and retrieve their English names for mapping in your Date/Time Formatter.