Answered

How to convert datetime to text in calculated field

(0) Share

Report

Posted on 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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Deeny ,

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

Best Regards,

Bof

Was this reply helpful? Yes No
Deeny 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Deeny 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No