Software Venture Consulting

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

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


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

HolidaysAUS ( theYear )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 5.0  (23 votes)
  Discuss this Custom Function

Vaughan Bromfield, Vaughan Bromfield Design
http://google.com

Creates a paragraph-delimited list of dates for Australian national holidays.

Sample Input:
HolidayAUS ( 2011 )
Sample Output:
3/01/2011
26/01/2011
22/04/2011
25/04/2011
26/04/2011
13/06/2011
3/10/2011
26/12/2011
27/12/2011


 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

Description:

HolidaysAUS ( theYear )

http://www.briandunning.com/cf/1494

Written by Vaughan Bromfield
vbromfield@optusnet.com.au
vaughan.bromfield@me.com
vaughan.bromfield@gmail.com

v1.0 - 22 October 2012
v1.1 - 23 October 2012 -- added historical limits, changed to List()
v1.2 - 23 October 2012 -- allowed for ANZAC Day clash with Easter Monday in 2011

Returns a list of paragraph-delimited dates for Australian national public holidays. Does not return dates that fall on Saturday or Sunday.
The holiday list has a NSW bias and includes the NSW dates for Queens Birthday and Labour Day.
An attempt has been made to include the proclamation years of the holidays to give them historical limits, but these are not complete nor 100% correct.
Arguably I could exclude any year before 1788 when Australia was first colonised by Europeans, or 1901 when Australia became independent from Britain.

Calculates the standard public holidays for Australia (actually NSW):
New Years Day
Australia Day
Good Friday
Easter Monday
ANZAC Day
Queens Birthday (All states except WA)
Labour Day (ACT, NSW, SA)
Christmas Day
Boxing Day

Includes code from the custom function
Easter_Sunday ( TheYear )
by Menno van Beek, STB Automatisering & Advies BV.
http://www.briandunning.com/cf/1473

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

This is my Custom Function and I want to edit it

Discuss:

All though your sample input is correct

RectangleArea ( 2 , 3 ) is 6 as seen in the saample output. I am not quite sure what this has to do with a cf that gets Austrailian holidays?

Robert Schaub, East Hampton CT
October 22, 2012 6:43am

Updated, thanks.

Vaughan, Sydney AUstralia
October 22, 2012 3:59pm

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

Your Name:
City/Location:
Comment:
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 6 + 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. NumberToHexadecimal(NumberValue)
  (Fri, Dec 08, 8:54am)
2. Get_BaseTable
  (Thu, Dec 07, 4:27pm)
3. JSONCreateVarsFromKeys ( json ; namespace )
  (Wed, Dec 06, 8:21pm)
4. GetTableNzme ( field )
  (Tue, Dec 05, 9:16pm)
5. TimeFormatAsText ( theTime )
  (Mon, Nov 13, 1:59pm)
6. ParseWebValueList( text )
  (Thu, Nov 02, 9:52am)
7. SVG_HTML_to_Text ( _svg_text ; _orig_text ;
  (Wed, Oct 25, 4:17am)
8. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)

RSS Feed of Custom Functions