Timestamp functions in FileMaker: Timestamp, GetAsTimestamp, date arithmetic

Intermediate

Timestamps combine a date and time into a single value. Learn how to construct and parse timestamps, perform time arithmetic, and handle the common pitfalls of timestamp comparisons.

What you'll learn

  • How to construct a timestamp from a date and time with Timestamp()
  • How to perform date and time arithmetic using timestamp values
  • How to extract date and time components from a timestamp

FileMaker timestamps are stored as the number of seconds since January 1, 0001 — making date/time arithmetic straightforward once you understand the underlying number format.

1/3
1

Construct a timestamp from date and time

Timestamp ( date ; time ) combines a date and a time into a single timestamp value. Use Get(CurrentTimestamp) for the current moment.

FileMaker Script
Timestamp ( Date ( 12 ; 31 ; 2024 ) ; Time ( 23 ; 59 ; 59 ) )
// December 31, 2024 at 11:59:59 PM

// Current timestamp
Get ( CurrentTimestamp )
Date functions in FileMaker: Date, Day, Month, Year, DayName, DayOfYearAggregate functions in FileMaker: Sum, Count, Average, Max, Min

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

Sign in to FM Dojo