AnsweredAssumed Answered

Is there a way to format a date field in a calculation?

Question asked by oldgustav on Mar 23, 2017
Latest reply on Mar 23, 2017 by rgordon

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.

Outcomes