Brian Dunning's FileMaker Custom Functions

DateWrittenOut ( datefield )

Converts a date field to written text

  Average rating: 4.8 (28 votes) Log in to vote

Jonathan Ray   Jonathan Ray
Richard Carlton Consulting
http://www.rcconsulting.com

Share on Facebook Share on Twitter

  Sample input:
DateWrittenOut(3/21/1989)
  Sample output:
Tuesday, March 21, 1989

  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.

 

Comments

Bob D   Bob D, Minneapolis
May 25, 2011
This can be done in one line of code.

DayName(datefield) & ", " & MonthName(datefield) & " " & Day(datefield) & ", " & Year(datefield)
 

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.