RelativeMonthCheck ( Text )

Necessary for AmbiguousDate(Text) function

Average rating: 4.6 (33 votes) Log in to vote

Lewis Buckingham
none
none

Sample input:

RelativeMonthCheck(3 Dec 1985);
RelativeMonthCheck(Late 1867);

Sample output:

1;

0;

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

If ( (PatternCount ( Text ; "Jan" )  =  1) or (PatternCount ( Text ; "Feb" )  =  1) or (PatternCount ( Text ; "Mar" )  =  1) or (PatternCount ( Text ; "Apr" )  =  1) or (PatternCount ( Text ; "May" )  =  1) or (PatternCount ( Text ; "Jun" )  =  1) or (PatternCount ( Text ; "Jul" )  =  1) or (PatternCount ( Text ; "Aug" )  =  1) or (PatternCount ( Text ; "Sep" )  =  1) or (PatternCount ( Text ; "Oct" )  =  1) or (PatternCount ( Text ; "Nov" )  =  1) or (PatternCount ( Text ; "Dec" )  =  1 ) ; 1 ; 0 )

Checks to see whether a month is mentioned in an ambiguous date.

Used by AmbiguousDate(Text) function to determine whether "Early", "Late", or "Mid" refers to a year or a month.

Comments

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

RelativeMonthCheck ( Text )

Comments

Support this website.

Support this website.