Forum Discussion

fgtom's avatar
fgtom
Copper Contributor
Jun 01, 2022

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 within a single cell:

==

First test: 2022/5/31  "Test was already performed"               

Second test: 2022/6/2    "Test will be performed soon" 

==

 

Is there a way for this?

microsoft lists

1 Reply

Sort By
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jun 01, 2022

    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)

Resources