cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
webdevguy
Level: Powered On

Date format is messed up all of a sudden!

I have a label defined as....

 

Text(Last_x0020_Updated,ShortDateTime) & " by " & ThisItem.Last_x0020_Updated_x0020_By

 

It was working fine but all of a sudden it's not. I'm not sure why. I would like it to show up as....

 

5/16/2018 7:45 PM by Robert Smith

 

But, now it's showing up as.....

 

2018-05-16T19:45:21.63TZ by Robert Smith

 

I even tried this to see if I could manipulate it at all, but it showed the same thing...

 

Text(ThisItem.Last_x0020_Updated,"[$-en-US]dd/mm/yyyy")

 

I even opened the data source file in Excel and made sure the columns were formatted correctly...

Format_Cells_and_InventoryTracker_xlsx.jpg

 

The only thing I believe I changed recently was how "Items" was defined for the gallery...

 

SortByColumns(
Search(
Filter(
Inventory,
Category=ddlFilterCategories.Selected.Value),
TextSearchBox1.Text,
"Category","Product_x0020_Name"
),
"Product_x0020_Name",
If(SortDescending1, Descending, Ascending)

 

But I don't think that should matter much.

 

Any ideas why?

 

Thanks!

1 REPLY 1
Lisabel0
Level 8

Re: Date format is messed up all of a sudden!

What is the data source of this app?

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,668)