Well look at that! I figured it out myself.
Probably totally clugey, but it works
I created a field for each part of the date
TR1 Site Survey Day:
If(
ToText(DayOfWeek())="0", "Sunday",
ToText(DayOfWeek())="1", "Monday",
ToText(DayOfWeek())="2", "Tuesday",
ToText(DayOfWeek())="3", "Wednesday",
ToText(DayOfWeek())="4", "Thursday",
ToText(DayOfWeek())="5", "Friday",
ToText(DayOfWeek())="6", "Saturday"
)
TR1 Site Survey Month:
If(
ToText(Month())="1", "January",
ToText(Month())="2", "February",
ToText(Month())="3", "March",
ToText(Month())="4", "April",
ToText(Month())="5", "May",
ToText(Month())="6", "June",
ToText(Month())="7", "July",
ToText(Month())="8", "August",
ToText(Month())="9", "September",
ToText(Month())="10", "October",
ToText(Month())="11", "November",
ToText(Month())="12", "December"
)
TR1 Site Survey Day of Month:
ToText(Day())
TR1 Site Survey Year:
ToText(Year())
Then I updated my formula rich text field to use the fields above
TR1 Site Survey Date BOLD:
"<b><span style='color: green; font-size:200%'>" & ToText( & " " & & " " & & " " &) & "</span>"
It's a thing of beauty!
BUT...
If anyone has an easier way to do it, I would welcome any suggestions ;)
Kim
