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

Date Formatting Keeps Messing Up

For some reason my app randomly puts in the wrong date format into the Excel that ends up messing up a few caluclations in the app itself. 

 

I even got to the point where I put my input format on the app to:

DateValue(ShortDate,"en-US")

 

And it works and puts the date as 11-29-2017 but then randomly it starts puting the date into Excel as 2017-11-29T06:00:00.000Z

5 REPLIES 5
Power Apps Staff anousham
Power Apps Staff

Re: Date Formatting Keeps Messing Up

Hi Adash,

 

Is your excel sheet for that column has a different date/time format? Would you mind checking to ensure, the column of the excel itself is not enforicing another format?

 

Thanks!

Anonymous
Not applicable

Re: Date Formatting Keeps Messing Up

I have it set to Short Date formatting and then reupload to OneDrive

Power Apps Staff Hemanth
Power Apps Staff

Re: Date Formatting Keeps Messing Up

Hi Adash,

How are you writing back to Excel? is it an excel in OneDrive or DropBox? Just trying to isolate where the issue could be.

Anonymous
Not applicable

Re: Date Formatting Keeps Messing Up

It's hosted on OneDrive for Business

Power Apps Staff Hemanth
Power Apps Staff

Re: Date Formatting Keeps Messing Up

Hi Adash,

Great. Can you start fiddler and capturing the networking events and reproduce the issue? Then save and attach the fiddler trace here?

 

 

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 (4,328)