cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Label doesn't show correct date from a DatePicker

So I have this Label where with its text function: DateValue(Text(DateValue1.SelectedDate, "[$-en-US]dd/mm/yyyy")) + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)
Now the problem is that if I choose in the DatePicker (DateValue1) the date 17/07/2019 (I changed its format to be "dd/mm/yyyy")  and any other value for the hours and minutes then the label bugs(?) and shows me "5/7/2020 XX:YY AM/PM" which is not the date I chose in the DatePicker.

How do I get around this issue? My computer setttings are already set to work with the european date but Powerapps still shows me the date in the "AM/PM" format and if I don't change the date format it automatically changes in the label even if th DatePicker is in the dd/mm/yyyy format.

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Label doesn't show correct date from a DatePicker

Resolved it by creating a string instead of a date with this:

Text(DateValue1.SelectedDate, "[$-pt-PT]dd/mm/yyyy") &""& " " &""& HourValue1.Selected.Value &""& ":" &""& MinuteValue1.Selected.Value

Then I changed the display of my date column to a string instead of a date and it works fine for now.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Re: Label doesn't show correct date from a DatePicker

Resolved it by creating a string instead of a date with this:

Text(DateValue1.SelectedDate, "[$-pt-PT]dd/mm/yyyy") &""& " " &""& HourValue1.Selected.Value &""& ":" &""& MinuteValue1.Selected.Value

Then I changed the display of my date column to a string instead of a date and it works fine for now.

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 452 members 4,850 guests
Please welcome our newest community members: