cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sonyat810
Regular Visitor

How to change date and time yo just date in a datacard

How to only show date and not time in a datacard field, Its disabled for me.

Sonyat810_0-1662466093828.png

 

10 REPLIES 10
BCBuizer
Super User
Super User

Hi @Sonyat810 ,

 

If you click on the Advanced Tab, you'll have the option to unlock the datacard which allows you to edit it:

 

BCBuizer_0-1662467115489.png

Once unlocked, you can use the Text Function to remove the date, assuming Parent.Default is referencing a Date/Time column:

 

Text(Parent.Default,"dd/mm/yyyy")


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Sonyat810
Regular Visitor

It's not updating my excel sheet now. 

BCBuizer
Super User
Super User

Hi @Sonyat810 ,

 

Can you please provide a bit more context? What is not updating your Excel sheet?



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Sonyat810
Regular Visitor

Ok, I see that its updating my excel sheet which is connected to power BI. But I still see the timestamp

Sonyat810_0-1662467924210.png

 

Sonyat810_1-1662468293360.png

 

BCBuizer
Super User
Super User

Hi @Sonyat810 ,

 

As you'll see in other posts in the community, Excel isn't the best data source to use, especially for date/time since there is no validation. I suggest you either 1. change data sources, for instance to Sharepoint (where you can disable time values) or 2. accept that the time value is there and implement solutions such as above to make sure the time value is not displayed.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

I remove the hour and mins, but it keeps showing up in my excel sheet

My excel sheet is linked to power bi

BCBuizer
Super User
Super User

Hi @Sonyat810,

 

There is no safe way to remove the time from Excel because the Excel connector will keep sending time values. This is why you should choose to live with it, or move to a data source that can accommodate your request.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,803)