6 Replies Latest reply on Mar 23, 2017 12:47 PM by rgordon

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

    oldgustav

      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.