FormatDate ( DatetoFormat )
//Returns Mon, Dec 8
Average rating: 4.3 (36 votes) Log in to vote
|
Catherine Dillimore Digital Fusion Ltd http://www.digitalfusion.co.nz |
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, 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, 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) ) |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.