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

Displaying calculated dates in short form without time in a form

I have a detail screen in my app which is used to show asset details for my company assets, two critical dates for us are the Next Service Date and the Warranty Expiry Date both of these values are calculated in my SharePoint list and when I add the fields to the Detail Form they are displaying in the following format 2012-06-31T23:00:00Z, whereas what we really need is this format 31-06-2021.

How can I define this formatting? 

3 REPLIES 3
Resolver I
Resolver I

Hi, 

 

Use the Text(Now(),ShortDate)

Instead of Now() you can use your database column name of date. 

 

 

 

 

Post Prodigy
Post Prodigy

Hi,

 

Here is the date format detail in powrapps

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times

 

Text ( Formula),"DD-MM-YY")

You can use:

Left(TextBox1.Text,Find("T",TextBox1.Text)-1)
Assuming the your data is in TextBox1, put the formula in another textbox2
 
If the data is in a Table, create a Collection:
ClearCollect(CollNewTable, AddColumns(YourTable,"NewDate",Left(Date,Find("T",Date)-1)))
 
Then use the collection which has the converted table: CollNewTable
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,257)