FileMaker Pro Custom Functions

/* Name: date.format History: Created by Tim Anderson, Tim Anderson Group www.timanderson.co.uk Creation Date: 3 August 2008 Last Modified Date: 3 August 2008 Purpose: A function to return a date in a text format specified at the time. Parameters: theDate format Example: date.format( get(currentdate); dd-mon-yy) - returns 03-Aug-08 Requires Other Custom Functions: None Other Notes: Uses substitute function so is very simple for you to add your favourite abbreviation - just watch the substitution order!. Thought I'd seen something like this before, but couldn't find it Options: None */ Let( _date = GetAsDate(theDate); Substitute(format; ["dd"; Right ("0"& Day (_date);2)]; ["mm"; Right ("0"& Month (_date);2)]; ["yyyy"; Year (_date)]; ["yy"; Right ("0"& Year (_date);2)]; ["year"; Year (_date)]; ["month"; MonthName (_date)]; ["mon"; Left (MonthName (_date);3)]; ["dname"; DayName (_date)]; ["dn"; Left (DayName (_date);3)]; ["year"; Year (_date)]) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.