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.

1/2
1

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 FileMakerTimestamp functions in FileMaker: Timestamp, GetAsTimestamp, date arithmetic

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo