You’re offline. This is a read only version of the page.
Hello
i am building an app to record information, my date picker default is Today(), but after saved, the date is minus 1 day compare today() in my data source (excel file). but when i display the record in gallery, the date is my submit date.
for example: ID 197 and 198, date is 5/11/2020 12:00 AM in Gallery shown, but the date is 5/10/2020 16:00 in data source.
could someone help me solve this issue?
Gallery
datasource
Hi @Bruce_Fei ,
Based on the issue that you mentioned, I think this issue is related to Time Zone. Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side.
When saving date time value back to Excel table from canvas app, it would convert the submitted date time value from canvas app into UTC format, then save the UTC format date time value back to Excel Table.
I have made a test on my side, please consider take a try with the following workaround:
Within the Edit form, set the Update property of the Date time field data card to following:
Share
Report
All responses (
Answers (DateAdd(DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0), -TimeZoneOffset(DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)), Minutes)set the Default Property of the Date Time field data card to following:
DateAdd(ThisItem.'Due Date', TimeZoneOffset(), Minutes)
If you want to reference the stored Date time value from your Excel table in Gallery, please use the following formula:
Set the Text property of the Label to following:
DateAdd(ThisItem.'Due Date', TimeZoneOffset(), Minutes)
Within your Detail Form, set the Default property of the Date time field data card to following:
DateAdd(ThisItem.'Due Date', TimeZoneOffset(), Minutes)
Please consider take a try with above solution, check if the issue is solved.
Best regards,
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
