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
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.
Pratice: Try your hand at using Day() , Month(), and Year()
Done
Set an automation to run only on the 3rd and 10th of every month