Skip to content
Gallery
Coda Template : Days, Weeks and Months
Share
Explore
Extra

icon picker
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
USA date
Formated EU Date
Coda EU date
1
6/1/2021
01/06/2021
01/06/2021
2
7/1/2021
01/07/2021
01/07/2021
3
8/1/2021
01/08/2021
01/08/2021
4
9/1/2021
01/09/2021
01/09/2021
There are no rows in this table

Format("{2:00}/{1:00}/{3}", thisRow.[USA date].Split("/"))
On the canvas using Today() in EU format
26/08/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
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.
10/9/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.