We are using FMP 12 Advanced, we have a layout in which we print an award certificate. We would like to be able to create a calculation field that draws from an existing date field (call the existing date field: "Date Awarded") the contents of that field would be a date value ex: 2/2/2012 this date may be a past, current, or future date, and will vary depending upon the actual date awarded. We would like to be able to add a calculation field (based on the "Date Awarded" field) which pulls the numerical representation of the example date "2/2/2012" and have it represented as a spelled out word: i.e. "This second day of December, two thousand and twelve". Further inputing "<<spelled out date>>" into our layout.
Thus far using a case function (found on briandunning.com) we are able to accomplish this for the date and month, but not for the worded year, here is what we have so far:
Case(
Day( Date Awarded ) = 1;"First of " & MonthName( Date Awarded ) & " " & Year( Date Awarded );
Day( Date Awarded ) = 2;"Second of " & MonthName( Date Awarded ) & " " &Year( Date Awarded );
Day( Date Awarded ) = 3;"Third of " & MonthName( Date Awarded ) & " " &Year( Date Awarded );
//….ETC. through the 31st of the month
Day( Date Awarded ) = 30;"Thirtieth of " & MonthName( Date Awarded ) & " " &Year( Date Awarded );
Day( Date Awarded ) = 31;"Thirty-first of " & MonthName( Date Awarded ) & " " &Year( Date Awarded )
)
The problem is we cant figure out how to get the year to represent as a worded value i.e.: two thousand and twelve, or nineteen hundred and ninety nine, or two thousand and thirteen...
Any help would be much appreciated. :-)
