"Day text" formatted so that the first letter is Uppercase?
I have a calculation field where a date is showing up as text in this way:
DayText &" " &Day ( date ) & ". " & MonthName ( date ) &" "& DateYear
I want to have the day name written with the first letter Uppercase, as Friday, not friday. I can do this by formatting the fields text style as "Title Caps", but the content of this field is published to html on the web, and a text style formatting within Filemaker does not affect what comes on the web.
So the question is if I can do something (with the formula?) that forces the date-as-text to show up with the first letter Uppercase.