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
http://www.digitalfusion.co.nz

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

 

Comments

Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 8, 2016
Hello!
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
Thanks
Cath

//Returns Wed May 4 2016


Let([
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 ) & " " &
Year(DatetoFormat)
)
 

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.