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

[kohrt]

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!

[rebeccas]

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]

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

[rebeccas · Accepted solution]

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!

[kohrt]

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

[rebeccas]

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