© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_17

17. Date, Time, and Timestamp Functions

Mark Conway Munro

(1)Lewisburg, Pennsylvania, USA

These three categories provide functions that manipulate date and time values.

Date Function Reference

Date functions are used to create and manipulate dates. FileMaker provides the following built-in date functions:

  • Date

  • Day

  • Day Name

  • DayNameJ

  • DayOfWeek

  • DayOfYear

  • Month

  • MonthName

  • MonthNameJ

  • WeekOfYear

  • WeekOfYearFiscal

  • Year

  • YearName

Date

The Date function creates a date object from separate numeric month, day, and year values.

Format

Date ( month ; day ; year )

Parameters

month = a number indicating a month.

day = a number indicating ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.