Forum Discussion
fgtom
Jun 01, 2022Copper Contributor
Is it possible to display date in a column that is not date column?
I'm thinking to combine multiple information into one column, but I'm having trouble with displaying date value, which will be shows as serial number. For example, I would like to do like this wi...
RobElliott
Jun 01, 2022Silver Contributor
fgtom whilst I can't think why you would want to combine columns as it will make filtering, views etc much more difficult, it is possible even with a DateTime column by creating a calculated column using a formula like this:
=CONCATENATE(Title&" "&TEXT([Review Date],"dd/MM/yyyy")&" "&Region&" "&Result)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)