GetMonthAsNumber ( monthTxt )

Converts month name to it's ordinal value

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

Simon Brown
Beezwax Datatools, Inc.
http://beezwax.net/

Sample input:

GetMonthAsNumber ("feb")

Sample output:

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

Case (
  monthTxt = "jan"; 1;
  monthTxt = "January"; 1;
  monthTxt = "feb"; 2;
  monthTxt = "February"; 2;
  monthTxt = "mar"; 3;
  monthTxt = "March"; 3;
  monthTxt = "apr"; 4;
  monthTxt = "April"; 4;
  monthTxt = "may"; 5;
  monthTxt = "jun"; 6;
  monthTxt = "June"; 6;
  monthTxt = "jul"; 7;
  monthTxt = "July"; 7;
  monthTxt = "aug"; 8;
  monthTxt = "August"; 8;
  monthTxt = "sep"; 9;
  monthTxt = "September"; 9;
  monthTxt = "oct"; 10;
  monthTxt = "October"; 10;
  monthTxt = "nov"; 11;
  monthTxt = "November"; 11;
  monthTxt = "dec"; 12;
  monthTxt = "december"; 12;

  // default
  0
)

/* ----------------------------------------

 # Function:         Convert a month string, either full name or 3 char abbreviation, into its ordinal value
 # Parameters:      monthTxt: String to be converted
  # Created:          2008-Jan-15 simon_b beezwax.net
 # Modified:         
 # Author:            Simon Brown

---------------------------------------- */

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.

Comments

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

GetMonthAsNumber ( monthTxt )

Comments

Support this website.

Support this website.