Brian Dunning's FileMaker Custom Functions

FormatDate ( DatetoFormat )

//Returns Mon, Dec 8

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

Catherine Dillimore   Catherine Dillimore
Digital Fusion Ltd

Share on Facebook Share on Twitter

  Sample input:
FormatDate ( "08/12/2008" )
  Sample output:
Mon, Dec 8

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

Formats a date to display as

Short day: Mon, Tues, Wed, Thurs, Fri, Sat or Sun
Short Month: Jan, Feb etc



Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 8, 2016
The Function does not show the year. Why?
And why don't you use FileMaker's convention of one space between all terms and separators as it is required in the upload dialog?
Cath Kirkland   Cath Kirkland, Digital Fusion
May 8, 2016
Hi Thomas,

You could change this function to work as you require and return the following

//Returns Wed May 4 2016

DayNameShort = Substitute(DayName ( DatetoFormat ); ["urday";""]; ["nes";""]; ["day";""]);
MonthNameShort= Substitute(MonthName ( DatetoFormat);[ "January"; "Jan"];["February"; "Feb"];["March"; "Mar"];["April"; "April"];["May"; "May"];["June"; "June"];["July"; "July"];[ "August"; "Aug"];["September";"Sept"];["October"; "Oct"];["November"; "Nov"];["December";"Dec"] )

DayNameShort & " " &
MonthNameShort & " " &
Day ( DatetoFormat ) & " " &

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: