Brian Dunning's FileMaker Custom Functions

GetMonthAsNumber ( monthTxt )

Converts month name to it's ordinal value

  Average rating: 3.8 (36 votes) Log in to vote

Simon Brown   Simon Brown
Beezwax Datatools, Inc.

Share on Facebook Share on Twitter

  Sample input:
GetMonthAsNumber ("feb")
  Sample output:

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

Convert a month string, either full name or 3 char abbreviation, into its ordinal value. This is a trivial but handy function, but the main reason I'm posting is that it is required for the GetTextAsDate function I've also posted.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.