cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular 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
Highlighted
Resolver I
Resolver I

Re: Displaying calculated dates in short form without time in a form

Hi, 

 

Use the Text(Now(),ShortDate)

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

 

 

 

 

Highlighted
Resolver V
Resolver V

Re: Displaying calculated dates in short form without time in a form

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")

Highlighted
Super User III
Super User III

Re: Displaying calculated dates in short form without time in a form

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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,688)