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

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

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
rebeccas
Community Champion
Community Champion

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. 

Anonymous
Not applicable

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

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!

Anonymous
Not applicable

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

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,799)