Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

CalendarLite ( date_field ; option ; iteration ; x_start_on_monday ; x_highlight_weekends ; holiday_list )

Rate this function:  

  Average rating: 4.3  (35 votes)
  Discuss this Custom Function

Drew Wesley, Drewsol

Same as Calendar (minus documentation and integrated holiday list).

Sample Input:
CalendarLite ( "6/1/2012" ; "calendar" ; 3 ; "" ; "" ; "" )
Sample Output:
(Shows month of August 2012 in 42 repeating fields. Days outside of August are grayed.)

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed


Same as Calendar (minus the extra documentation and integrated holiday list).

Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it


Seems to be a nice idea for calendar.
But it doesn't seems to work.
This example return a 22 in grey color.
Should I miss something?
Do you have a simple example to download?
Could I have more details about the parameters?

Benoit Kaisin, Belgium
January 12, 2010 7:41pm

The documentation included in the full fnCalendar function provides the instructions you'll need. Please email me with any questions.

Andrew Butt, Los Angeles, CA
January 13, 2010 9:41am

Doesn't work; all but first cell empty.
Missing extend()?
1.5 worked OK.

Bruce Robertson, Redmond WA
February 01, 2010 11:51am

If you're using the global calculation option, you'll need (1) to use the date as a trigger field and (2) the Extend function as noted in Step 3a in the documentation:
Let (
trigger = CAL::Date_G ;
fnCalendar ( Extend ( <date field> ) ; "calendar" ; 1 ; "" ; "" )

Andrew Butt, Los Angeles, CA
May 29, 2010 2:45pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 9 + 9 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ExcludeValues(MyList ; Out)
  (Wed, Mar 21, 7:23am)
2. PreviousMonthEndDate ( myDate )
  (Wed, Mar 07, 3:35am)
3. PreviousMonthName (myDate)
  (Wed, Mar 07, 3:33am)
4. FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
  (Fri, Mar 02, 6:32am)
5. sql.getTable ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:36am)
6. sql.getField ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:34am)
7. FilterOut ( ListA ; ListB )
  (Wed, Feb 21, 6:11pm)
8. Char0 ( )
  (Sun, Feb 18, 2:35am)

RSS Feed of Custom Functions