At present, the date field in the calculation field 'message' appears as, for example, '23 March'. What I'd prefer is for it to appear as '23rd March'.
The relevant block of 'code' in the calculation field looks like this:
& " " & "on or before" & " " & Day ( SampleEvents::BalanceDueDate ) &" " & MonthName ( SampleEvents::BalanceDueDate ) & "." &" " & "When it comes through, we'll send an email acknowledging safe receipt, along with useful information about your stay." & ¶ & ¶ &
Apologies if it is not very elegant, but it works!
Does it need something after the 'Day' function to achieve the formatting - ie. the 'th', 'rd', 'nd' and 'st' ?
Thanks in anticipation.