Is it possible to display date in a column that is not date column?

%3CLINGO-SUB%20id%3D%22lingo-sub-3453002%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20display%20date%20in%20a%20column%20that%20is%20not%20date%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3453002%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20thinking%20to%20combine%20multiple%20information%20into%20one%20column%2C%20but%20I'm%20having%20trouble%20with%20displaying%20date%20value%2C%20which%20will%20be%20shows%20as%20serial%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20would%20like%20to%20do%20like%20this%3CFONT%20color%3D%22%23DF0000%22%3E%20within%20a%20single%20cell%3C%2FFONT%3E%3A%3C%2FP%3E%3CP%3E%3D%3D%3C%2FP%3E%3CP%3EFirst%20test%3A%202022%2F5%2F31%26nbsp%3B%20%22Test%20was%20already%20performed%22%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%20test%3A%202022%2F6%2F2%26nbsp%3B%20%26nbsp%3B%20%22Test%20will%20be%20performed%20soon%22%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%3D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3453002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3455640%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20display%20date%20in%20a%20column%20that%20is%20not%20date%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3455640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1407937%22%20target%3D%22_blank%22%3E%40fgtom%3C%2FA%3E%26nbsp%3Bwhilst%20I%20can't%20think%20why%20you%20would%20want%20to%20combine%20columns%20as%20it%20will%20make%20filtering%2C%20views%20etc%20much%20more%20difficult%2C%20it%20is%20possible%20even%20with%20a%20DateTime%20column%20by%20creating%20a%20calculated%20column%20using%20a%20formula%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONCATENATE(Title%26amp%3B%22%20%22%26amp%3B%3CSTRONG%3ETEXT(%5BReview%20Date%5D%2C%22dd%2FMM%2Fyyyy%22)%3C%2FSTRONG%3E%26amp%3B%22%20%22%26amp%3BRegion%26amp%3B%22%20%22%26amp%3BResult)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22concatenate3.png%22%20style%3D%22width%3A%20351px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22concatenate3.png%22%20style%3D%22width%3A%20351px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376778i9BE61972B7A9F806%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22concatenate3.png%22%20alt%3D%22concatenate3.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

1 Reply

@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)

 

concatenate3.png

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