Brian Dunning's FileMaker Custom Functions

Current Month_Abreviation

Easy Way of getting a short Month (Of current Month Date)

  Average rating: 4.5 (27 votes) Log in to vote

Walter Noia   Walter Noia
Digi
http://www.digidelta.pt

Share on Facebook Share on Twitter

  Sample input:
January
Febuary
March
April
  Sample output:
JAN
FEB
MAR
APR

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

Easy way of getting a 3 letter month format
field. or a Global field, calculation field or
a variable

with the current date

 

Comments

HazMatt   HazMatt, Blaine, MN USA
Oct 20, 2012
Your sample output isn't accurate, strictly speaking. You would need to enclose everything in the Upper() function to get upper case letters.

Also, this would be made a whole lot more useful as a custom function if you accepted a date as a function parameter. Then you could get the 3 digit abbreviation for any date you wanted, instead of just the current date. Something like this:
Upper(Left(MonthName(TheDate); 3))
 

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.

Under construction. Email me your wish list for improvements.