web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Creating Calculated Fi...

Power Apps

Unanswered

Creating Calculated Field to pull date only from Modified On CDS Standard field

(0) Share

Report

Report

Posted on by msross

Hi all,

First time posting an inquiry here. Let me know if I'm missing anything in order to help provide a solution:

I am trying to create an entity field that will reference the date only from a "Modified On" entity field that is a standard type field to my CDS entity. (EX: The Modified On field values typically looks something like: "2020-04-27T17:59:15Z" ; I would like to create a separate calculated field that references only "2020-04-27").

I appreciate any assistance in advance.

Thank you!

M. Ross

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @msross :
Do you want to get a value in "2020-04-27" format instead of "2020-04-27T17:59:15Z" ?
The point is whether "2020-04-27" or "2020-04-27T17:59:15Z" are just strings, they look different because they use different target formats when converting from time values to strings.
You can easily achieve it through the text function without creating new columns.
Text(The value of the specified date,"[$-en]yyyy-mm-dd")
I’ve made a test for your reference.
My data source:Accounts()
1\Add a data table control
Items: Accounts

2\set the modified On column’s text property to:
Text(ThisItem.'Modified On',"[$-en]yyyy-mm-dd")

I think this link will help you a lot:
Text function in Power Apps
Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation