Unanswered

Displaying calculated dates in short form without time in a form

(0) Share

Report

Posted on by Alnwick

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

VDS_Mantra 175 on at

Like (0)

Report

Hi,

Use the Text(Now(),ShortDate)
Instead of Now() you can use your database column name of date.

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (0)

Report

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

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No