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!
Solved! Go to 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!
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.
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!
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!
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |