U.M. (Windows)

Summary of functions C-5
Date functions
Syntax Definition
Date (month, day, year) Returns the calendar date of month, day, year (in digits),
from January 1, 0001, in the date field format you’ve set
in your computer system software. Year must be four
digits.
DateToText (date) Converts date to text
Day (date) Returns a number representing the day portion of date
DayName (date) Returns the weekday name of date
DayofWeek (date) Returns the weekday position of date, from Sunday (1)
through Saturday (7)
DayofYear (date) Returns the number of days elapsed since January 1 of
the year in date
Month (date) Returns a number representing the month portion of
date
MonthName (date) Returns the month name based on the date provided
Today Returns the current date
WeekofYear (date) Returns the number of weeks elapsed since January 1 of
the year in date, counting fractions of weeks as whole
weeks
WeekofYearFiscal
(date, starting day)
Returns the number of weeks elapsed since the first
week of the year of date, using starting day (a number
from 1-7, where 1 is Sunday) as the first day of the
week. The first week of the year is a week that contains
four or more days of that year.
Year (date) Returns a number representing the year portion of date
Choose FileMaker Help Index from the Help menu, and then type:
E date functions
?