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

Date from date picker is -1 day when saved in Excel

I have a DatePicker in a custom datacard within my form so the information will be saved in my Excel doc in OneDrive. When I select a date in my app the date in Excel shows up as -1 day (11/8/19 shows in Excel as 11/7/19). I changed the Date time zone from local to UTC and still have the problem. Currently the Data Properties for the DatePicker shows:

 

DefaultDate: Today()

DefaultTimeZone: DateTimeZone.UTC

Format: DateTimeFormat.ShortDate

InputTextPlaceholder: Text(Date(2001,12,31),DatePicker4_1.Format, DatePicker4_1.Language)

 

The Data Properties for the DataCard shows:

 

DataField: "Date"

DisplayName: "Date"

Update: DatePicker4_1.SelectedDate

MaxLength: DataSourceInfo([@BlaineDaily], DataSourceInfo.MaxLength, "Date")

 

This app will need to be used globally by people in many different timezones. I have not tested it with someone in a different timezone to see if the

 

Thanks for any help you can provide!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Date from date picker is -1 day when saved in Excel

USUALLY (unless there is a factor I am not thinking of) the "local" should then look to your browser for that information so you might check your settings there. 

 

I've also seen people use the browser settings to change the language displayed in their app (just FYI). 

 

Good luck!

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Date from date picker is -1 day when saved in Excel

Have you tried change the DateTimeZone of the date picker in your app to "Local"...that is what I typically use and from there it is dependent on your browser. 

kohrt
Level: Powered On

Re: Date from date picker is -1 day when saved in Excel

When I first had the problem the timezone was set to local. 

Super User
Super User

Re: Date from date picker is -1 day when saved in Excel

USUALLY (unless there is a factor I am not thinking of) the "local" should then look to your browser for that information so you might check your settings there. 

 

I've also seen people use the browser settings to change the language displayed in their app (just FYI). 

 

Good luck!

View solution in original post

kohrt
Level: Powered On

Re: Date from date picker is -1 day when saved in Excel

I just tried changing it to Local and now it works 🙄 I think I've been staring at a computer for too long...

Super User
Super User

Re: Date from date picker is -1 day when saved in Excel

lol...it happens. I have had so many moments like that! Glad you got it going!

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 (3,825)