JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Coda Template : Days, Weeks and Months
A go to template on date related issues
Days
Weeks
Months
Extra
More
Share
Explore
Extra
From USA to EU date formats
Turn USA date formats into EU dates
01/06/2021
01/07/2021
01/08/2021
01/09/2021
Source is USA format
Source is USA format
USA date
Formated EU Date
Coda EU date
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("/"))
Source :
European date formats default option
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
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.
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 (
Ctrl
P
) instead.