Category: Date

Syntax: DayOfWeek ( date )


DateAny valid date (1/1/000112/31/4000), expression that returns a date, or field that contains a date. The parameter can also be the numeric representation of a date (11460970).

Data type returned: Number


Returns a number from 1 to 7, representing the day of week (Sunday = 1, Saturday = 7) for any valid date (1/1/000112/31/4000).

DayOfWeek() can be used to perform conditional tests on days of week without concern for localization issues. The number returned is always the same regardless of what language version of FileMaker Pro the user is using. The number value returned by DayOfWeek() can also be used in mathematical calculations.

Note that the year is optional. DayOfWeek ("12/1") will return the appropriate integer for December 1st in the current year.




DayOfWeek ( "11/24/2003" )

Returns 2 (Monday).

DayOfWeek ( dateField )

Returns the day of week for the date stored in the field dateField.

DayOfWeek ( Date ( 12; 25; Year ( Get ( CurrentDate ))))

Returns the day number on which Christmas falls this year.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: