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

WRONG date showing in gallery - from Excel data

I created a canvas app and added a gallery (blank flexible height) using an Excel table as the data source. I added a label in the gallery and referenced a date from the Excel table; however the gallery is displaying the dates as one day prior to the date in my data (10/15/2018 in Excel shows as 10/14/2018 in the gallery, and 10/02/2018 shows as 10/01/2018). How can I make it display the correct dates?

 

Note: I also have a date picker on the screen and filtered my gallery to display anything with the date <= the date showing in the date picker. This appears to reference the Excel data correctly.

 

Any help would be VERY MUCH appreciated!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

Re: WRONG date showing in gallery - from Excel data

This is caused because of the TimeZone Dates.

 

I Got the same Date Difference using an excel spreadsheet as a Data Source, I had to do this formula.

Text ( DateAdd (ThisItem.Data; TimeZoneOffset(ThisItem.Data);Minutes) ; "[$-pt-BR]dd/mm/yyyy" ; "pt-BR" )

 

Hope this helps for you..

View solution in original post

LJ
Level: Powered On

Re: WRONG date showing in gallery - from Excel data

This worked great--thanks!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Re: WRONG date showing in gallery - from Excel data

This is caused because of the TimeZone Dates.

 

I Got the same Date Difference using an excel spreadsheet as a Data Source, I had to do this formula.

Text ( DateAdd (ThisItem.Data; TimeZoneOffset(ThisItem.Data);Minutes) ; "[$-pt-BR]dd/mm/yyyy" ; "pt-BR" )

 

Hope this helps for you..

View solution in original post

LJ
Level: Powered On

Re: WRONG date showing in gallery - from Excel data

This worked great--thanks!

View solution in original post

Helpful resources

Announcements
thirdimage

New Badges

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

Top Solution Authors
Top Kudoed Authors
Users online (5,169)