Answered

How to convert datetime to text in calculated field

Like (0) Share

Report

Posted on 31 May 2023 02:39:51 by Deeny

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.

All responses (4)

Answers (1)

Deeny 11 on 01 Jun 2023 at 06:31:01

Like (0)

Report

Re: How to convert datetime to text in calculated field

Hi @v-bofeng-msft , thanks for your reply, I'm trying to create real time process for this issue.
Verified answer

v-bofeng-msft on 31 May 2023 at 05:31:39

Like (0)

Report

Re: How to convert datetime to text in calculated field

Hi @Deeny ,

There is no such a function named 'TEXT' for calculated field

Please check this link:
https://learn.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn832103(v=crm.8)?redirectedfrom=MSDN

In addition , the formula column is also not work for 'Text' cause The Text and Value functions only work with whole numbers(https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns#functions)

Please consider using flow, triggering with 'when a row is added', and then updating this text field.

Best Regards,

Bof
Deeny 11 on 31 May 2023 at 03:38:55

Like (0)

Report

Re: How to convert datetime to text in calculated field

Hello, here is the screenshot, thanks for your investigation!

Capture.JPG
v-bofeng-msft on 31 May 2023 at 03:12:34

Like (0)

Report

Re: How to convert datetime to text in calculated field

Hi @Deeny ,

Could you please show me a screenshot? Where did you use the text function?

Best Regards,

Bof