Date functions in FileMaker: Date, Day, Month, Year, DayName, DayOfYear

Beginner

FileMaker has a rich set of date component functions. Learn how to construct dates from components, extract day/month/year, get day names, and calculate day-of-year values.

What you'll learn

How to construct a date from year, month, and day with Date()
How to extract date components with Day(), Month(), Year()
How to get human-readable date descriptions with DayName() and DayOfYear()

FileMaker stores dates as serial numbers (integers counting from January 1, 0001) and provides a set of functions to construct dates from components and extract components from dates.

Stuck is a valid status

Need a second brain on this one?

If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.

Book consulting

1/2

Construct a date from components

Date ( month ; day ; year ) builds a date from three integers. This is essential for constructing dates programmatically, like the first day of a month or a fixed anniversary.

FileMaker Script

# First day of the current month
Date ( Month ( Get ( CurrentDate ) ) ; 1 ; Year ( Get ( CurrentDate ) ) )

# Last day of the current month (first day of next month minus 1)
Date ( Month ( Get ( CurrentDate ) ) + 1 ; 1 ; Year ( Get ( CurrentDate ) ) ) - 1

# Build a specific date
Date ( 12 ; 31 ; 2024 )  // December 31, 2024

PatternCount(): searching and counting occurrences in FileMaker Timestamp functions in FileMaker: Timestamp, GetAsTimestamp, date arithmetic