Day, Month, & Year
Day, Month, & Year

⁠

Formulas: Day() , Month(), and Year()

Category: Dates/Times

⁠

Day()

⁠

Month()

⁠

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.

⁠

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