Sep 22 2021 05:57 AM
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!
Sep 22 2021 06:48 AM - edited Sep 22 2021 06:55 AM
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)
Sep 22 2021 06:48 AM - edited Sep 22 2021 06:55 AM
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)