# How to translate Date/Time formatting Tokens?

**URL:** https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189
**Category:** Questions
**Tags:** format-date
**Created:** [July 15, 2024, 6:53pm UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189 "2024-07-15T18:53:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Leander\_C\_Seidl](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/leander_c_seidl/32/38297_2.png) [@Leander\_C\_Seidl](https://community.make.com/u/Leander_C_Seidl)
#### Post date: [July 15, 2024, 6:53pm UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/1 "2024-07-15T18:53:50Z")

</div>

Im relying heavily on formatDate & the [Tokens for date/time formatting](https://www.make.com/en/help/functions/tokens-for-date-time-formatting#) to restructure a lot of dates in my files. In english this works perfectly:

```auto
​​formatDate (now; dddd, ​​MMMM ​​Do)

```

turns into “Monday, July 15th”.  
Which is a great for turning the complex “now” date into an easily readable, user-facing text.

Problem is, I also have an output that is in the german language. There, I would need the date to read “Montag, 15. Juli”. The different order can be achieved easily, but  
Monday → Montag & July → Juli, is my current obstacle.

Is there a way to achieve this with some changes to the Date/Time formatting Tokens?  
Otherwise, I was thinking of using a “replace” text parser module. Is that the most efficient way to do it? I’m a bit concerned, because with 12 months and 7 days, I’m afraid I’d have to run my text through 19 separate modules - I’d probably exhaust my operations in an inefficient way.

Grateful for any ideas!  
Leander

---

<div class="post-metadata">

### Author: ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)
#### Post date: [July 15, 2024, 8:36pm UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/2 "2024-07-15T20:36:19Z")

</div>

I would use 3 switch functions and basically bring it all together and get each part separately first.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/8/d858e64828c4142992eb03e63eb0c2c184b829b0.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/2/92e4829aba0ad901fa6b74b52a3ebbff0d9315b8.png)

Here is the formula (I don’t know German and just looked up the translations change as you need of course 🙂 )

{{switch(formatDate(now; “dddd”); “Monday”; “Montag”; “Tuesday”; “Dienstag”; “Wednesday”; “Mittwoch”; “Thursday”; “Donnerstag”; “Friday”; “Freitag”; “Saturday”; “Samstag”; “Sunday”; “Sonntag”)}}, {{switch(formatDate(now; “MMMM”); “January”; “Januar”; “February”; “Februar”; “March”; “März”; “April”; “April”; “May”; “Mai”; “June”; “Juni”; “July”; “Juli”; “August”; “August”; “September”; “September”; “October”; “Oktober”; “November”; “November”; “December”; “Dezember”)}} {{formatDate(now; “Do”)}}

---

<div class="post-metadata">

### Author: ![Leander\_C\_Seidl](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/leander_c_seidl/32/38297_2.png) [@Leander\_C\_Seidl](https://community.make.com/u/Leander_C_Seidl)
#### Post date: [July 15, 2024, 9:23pm UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/3 "2024-07-15T21:23:41Z")

</div>

Excellent @Mr.Make, thank you - this seems to be working indeed! I had to remove all the " from the formula, as that seemed to confuse the function (spitting out an empty result). But after I ran it without the ", it seems to be working as intended. I’m running a few more tests tomorrow, but I’m cofnident that this does the trick. Thank you again!

---

<div class="post-metadata">

### Author: ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)
#### Post date: [July 16, 2024, 1:28am UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/4 "2024-07-16T01:28:50Z")

</div>

Of course have a great one!!

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [July 16, 2024, 2:06am UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/5 "2024-07-16T02:06:34Z")

</div>

The opposite, parseDate, is mentioned here if you need it in future: [parseDate does not work for German Month names of March/May/October/December](https://community.make.com/t/parsedate-does-not-work-for-german-month-names-of-march-may-october-december/40038)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [July 29, 2024, 9:34pm UTC](https://community.make.com/t/how-to-translate-date-time-formatting-tokens/46189/6 "2024-07-29T21:34:04Z")

</div>


