How to get "long" date string when using conc...

(StudentHomes Plymouth) #1

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?

(StudentHomes Plymouth) #2

@Suvrutt_Gurjar thank you I’ll give it a try.

(StudentHomes Plymouth) #3

@Suvrutt_Gurjar That worked,

I was totally unaware of the SWITCH function. Thank you for your help.

(Suvrutt Gurjar) #4

@StudentHomes_Plymout, Thank you for update and good to know it worked as desired.

(Suvrutt Gurjar) #5

@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]))