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 - Show more from this author

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.