Unanswered

Date format in labels and datacard

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,

I have a, hopefully, quick question regarding date formats. My datacards show dates as MM/DD/YYYY, however here we are using format DD/MM/YYYY, and Excel sheet has dates as the latter format. How can I make it so the date in labels (for checking info or formulas) and datacards show it as DD/MM/YYYY?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous

You can use the Text function to change the formats of your dates.

In your case, you'd make the text property of the label Text(whateverDate, "dd/mm/yyyy")

I hope that is helpful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
@RandyHayes
That works perfectly for a label I use to test things in a gallery, however, I am not sure if I am doing it right or wrong in the case of a datacard in a form. In the form, I unlocked it to make changes to the 'text' condition, and typed:
Text(Parent.Default,"dd/mm/yyyy")
However, the info shown on it keeps being the same, no change whatsoever on the order itself.
And after the 'enter', the app shows the code now as:
Text(Parent.Default,"[$-en-US]dd/mm/yyyy")
What can I do?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

You might want to review information on the Language function. There are some specific statements in that document about determining the Language and/or Region.

Text will use the information returned from the hosting session and operating system for the language. If it cannot determine it, it will result in en-US. You can override it in your text format as well.

However, what is concerning to me is that you say you've changed the Text property of your control in your datacard to reflect this and there is no change. Which control did you change this on (presumably on the DataCardValuexx control)? What kind of control is it - Label, TextInput, etc.?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@RandyHayes
Not sure if it is affecting or not, but my internet connection and the PowerApps enviroment are both from the US, from the place I work at. I did try using [es-419] which I think was the correct one for my case, but didn't work.
Also, it is a detail form, I unlocked the datacard I wanted to change, and added the Text( xx, "dd/yy/mmmm") on it, with xx=Parent.Default; on the Text property of the DataCardValue. I assume by the symbol in the list of screens it is a label, though.

EDIT:
What worked was to do the "text" thing on the datacard itself, on the Default property, thus ending as:
Default: Text(ThisItem.'Comienzo Plan', "[$-en-US]dd/mm/yyyy]"
And I know it worked because it also does not show the HH:MM it had as default (without changes, I mean)

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous

Seems like that last edit did the trick for you.

I would say though, just be careful with converting dates into other locales. Not so much a problem from the conversion part, but, if you then use that localized date in another area, you will want to pay attention to the locale it was created under.

In other words, if you have "[$en-US]mm/dd/yyyy" and a result of 2/3/2019 (Feb 2 2019) and you then try to "use" that text value in a conversion (DateValue("2/3/2019") for example), AND the locale of the system that PowerApps is running is es, for example. Then you will end up with Mar 2 2019 from the conversion.

Always best to keep dates as dates and only convert them for display.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@RandyHayes
No worries on that part, the dates behind in the spreadsheet are in the 'correct' (local) format, it is only for seeing it on the app that I wanted to change it (:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Edit / Addon:
@RandyHayes Didn't mark as solved since I noticed something. I have an extra part where I leave the option to add a 'control date' so to speak, however, the date control is formatted as mm/dd/yyyy. Is it that way only or can it be changed to input as dd/mm/yyyy?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

What kind of control is the control date?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

@RandyHayes
Date? Not sure which one. However, I found the answer to this here:
https://powerusers.microsoft.com/t5/General-Discussion/Change-Date-Format-in-Datepicker/td-p/38063

(:

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous

Ah, a DatePicker control. Yes, you found your answer to that.

By the way, you can always determine what kind of control you are dealing with by clicking on it and then in the Properties pane, at the top, it will tell you what kind of control it is. That's always helpful to know so you can determine what you can do with it.

Was this reply helpful? Yes No