Brian Dunning's FileMaker Custom Functions

Calendar ( c_Date )

Require FM8+. Shows monthly calendar view with different colour for previous/next month days, Sundays and today. Custom function can be used as calculation field.

  Average rating: 3.9 (39 votes) Log in to vote

JERRY   JERRY

Share on Facebook Share on Twitter

  Sample input:
Calendar ("02/03/06")
  Sample output:
(May not show color or text styles)

29 30 31 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 1 2 3 4
5 6 7 8 9 10 11

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

// Calendar(c_Date) // c_Date -- Function Parameter
This calendar works very fast even though it uses text function extensively. In order to display this calendar properly use Text PARAGRAPH settings for the field ( exp. for Verdana10 I use Line Spacing 22 px and Tabs: 22,44,66,88,110,132,154 )

To pick the date put 42 transperent buttons on top and use script with parameter. Something like this:
Set DBDate to
Date(Month(c_Date);Get ( ScriptParameter )-DayOfWeek(Date(Month(c_Date);1;Year(c_Date)))+1; Year(c_Date))

 

Comments

Wilmer   Wilmer, Anaheim, Ca
Mar 26, 2009
HI Brian,

can you help me please I can't
pick up the date from the calendar can you help me with the script and parameter.

Thanks,

Wilmer
 

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.