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?
@Suvrutt_Gurjar thank you I’ll give it a try.
@Suvrutt_Gurjar That worked,
I was totally unaware of the SWITCH function. Thank you for your help.
@StudentHomes_Plymout, Thank you for update and good to know it worked as desired.
@StudentHomes_Plymout, You may wish to explore the following expression. The text length for the expression such as "First payment date:
1 September 2019" could need a long text type column?
=CONCATENATE(“First payment date: ” , DAY([FirstPaymentDate]),” “, (SWITCH(MONTH([FirstPaymentDate]), 1, January, 2, February, 3, March, 4, April, 5, May, 6, June, 7, July, 8, August, 9, September, 10, October, 11, November, 12, December, “Invalid date!”)),” “, YEAR([FirstPaymentDate]))
User | Count |
---|---|
42 | |
27 | |
25 | |
20 | |
13 |