Gallery
Day, Month, & Year
Share
Explore

icon picker
Day, Month, & Year

Formulas: Day() , Month(), and Year()
Category: Dates/Times
plus-1day.svg
Day()
plus-1month.svg
Month()
plus-1year.svg
Year()
Returns the day of the month from a given date
Another way to say it...
Hey Coda, can you extract the day shown in this date?
Returns the month from a given date
Or, as one might say...
Hey Coda, can you extract the month shown in this date?
Returns the year from a given date
Said differently...
Hey Coda, can you extract the year shown in this date?


All three formulas use the same, single parameter.
overtime (1).svg
DateTime

Day(DateTime)

The specific date from which you want to extract a day, month, or year.

Here’s a date value you can change:
10/18/2022
- Watch below to see what information our formulas draw out from this date 👇
Chosen Day:
18
Day()
Chosen Month:
10
Month()
Chosen Year:
2022
Year()
Notice that each of these formulas returns a number - specifically the number corresponding to the dates day, month, or year. These formulas are rather straightforward and are better learned in context. View below for some potential use-cases and then try your hand at actually creating those use cases in the activity section

Potential Use Cases

Running an automation on the third of every month (or any chosen day).
Grouping dates by a month or filtering by a month (same for year).
Finding dates within the current year for data analysis.

Done
Set an automation to run only on the 3rd and 10th of every month
Done
Group a large collection of dates by year
Done


Share
 
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.