SOLVED

Capitalise Month as text in concatenated field

Contributor

Hi Community 

I have a unique reference field created by concatenating a date field and a text field, but would like the month to print in capitals.

I have this formula but the month won't capitalise?

 

="CR"&TEXT([Review Date],UPPER("ddMMM"))&[Credit Ref]

 

this gives an output such as "CR21Sep12345678" , but I want "CR21SEP12345678"

 

Thanks! 

2 Replies
best response confirmed by markikav1955 (Contributor)
Solution

@markikav1955  the formula should be ="CR"&UPPER(TEXT([Review Date],"DDMMM"))&[Credit Ref]

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thank you very much Rob!