How to get “long” date string when using concatenate? I am trying to
construct a string using a date field but would like the date to appear
in UK long date format. Using =CONCATENATE("First payment date:
",TEXT([FirstPaymentDate])) the result appear...