Brian Dunning's FileMaker Custom Functions

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

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

  Average rating: 4.1 (33 votes) Log in to vote

Drew Wesley   Drew Wesley
Drewsol
http://www.drewsol.com

Share on Facebook Share on Twitter

  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.)

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

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

 

Comments

Benoit Kaisin   Benoit Kaisin, Belgium
Jan 12, 2010
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?
Thanks
Ben
 
Andrew Butt   Andrew Butt, Los Angeles, CA
Jan 13, 2010
The documentation included in the full fnCalendar function provides the instructions you'll need. Please email me with any questions.
 
Bruce Robertson   Bruce Robertson
Feb 1, 2010
Doesn't work; all but first cell empty.
Missing extend()?
1.5 worked OK.
 
Andrew Butt   Andrew Butt, Los Angeles, CA
May 29, 2010
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 ; "" ; "" )
)
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.