DateWrittenOut ( datefield )
Converts a date field to written text
Average rating: 4.8 (28 votes) Log in to vote
Richard Carlton Consulting
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Using the let function to simplify matters, this function allows a developer to take the contents of a date field and spell it out in its entirety in a calculated text field.
One of the advantages of doing this is that one can "color coat" the text field based on the Day using the DayofWeek function within FileMaker. To do this, a separate Case statement can be added with separate RGB values for each day of the week.
Bob D, Minneapolis
May 25, 2011
This can be done in one line of code.
DayName(datefield) & ", " & MonthName(datefield) & " " & Day(datefield) & ", " & Year(datefield)
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.