Date Formater - German language

[rudi]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZmMDYzMjA0MzQ1MjZlNTUzMjUxMzMi_pc

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

 

[ArshilAhmad]

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.