Forum Discussion
Solved
Capitalise Month as text in concatenated field
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 capitali...
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)
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!