From USA to EU date formats

Turn USA date formats into EU dates

⁠

01/06/202101/07/202101/08/202101/09/2021

⁠

Source is USA format

Source is USA format

USA date

Formated EU Date

Coda EU date

6/1/2021

01/06/2021

7/1/2021

01/07/2021

8/1/2021

01/08/2021

9/1/2021

01/09/2021

There are no rows in this table

⁠

Format("{2:00}/{1:00}/{3}", thisRow.[USA date].Split("/"))

Source :

European date formats default option⁠

⁠

On the canvas using Today() in EU format

05/11/2024

⁠

via applying Format. Notice that Format() is about Nth() values in a list. This sounds complicated, but it is mainly a matter of getting used to.

Format(

"{1:00}/{2:00}/{3}",

Today().Day(),

Today().Month(),

Today().Year()

)

A better alternative is in many cases this

one⁠

⁠

Split(formatdatetime(Today(),7,4),",").first()

This is the one I prefer, because as the author mentions, it is compact and it permits for adding days in a simple manner, like below I added 15 days.

⁠

20/11/2024

⁠

Split(formatdatetime(Today() + Days(15),7,4),",").first()

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.