I'm trying to create a calculated column in a table and set the data type as Single line of text. I want to get the text value of createdon, which is datetime type, but can't find a possible solution on this, does anyone know about it?
I tried to use Text(createdon, "dd/MM/yyyy hh:mm:ss"), but it shown that The TEXT function doesn't exist.