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 appears as “First payment date: 01/09/2019”
Problem is I would like it to appear as "First payment date:
1 September 2019"
Any ideas how I can achieve this?