Forum Discussion

rizwanmgm's avatar
rizwanmgm
Copper Contributor
Jan 10, 2024

SP-Single Line Of Text Column as date issue

Dear Experts,

I have a text column which stores the dates as dd-mm-yyyy for example

12-02-2024

10-01-2024

15-01-2024

i have created a calculated column to datetime using formula =TEXT([DateText],"dd/mm/yyyy")

the output coming is as below

02/12/2024

01/10/2024

15-01-2024

I want to show the calculated column in format dd/mm/yyyy

 

please advice

No RepliesBe the first to reply