英文:
How to exclude time value from a date value?
问题
我有一个与表单和画廊连接的Excel文件，还有一个添加按钮，如截图所示。
问题是它在Excel文件中包括时间。而且日期以(选择的日期-1)和22:00或00:00的形式减少了一天。
有人知道如何修复吗？
我尝试过这个：
时间仍然包括，如您所见...
英文:
I have an excel file connected to a form and a gallery in my power app. I also have an add button which adds values as seen in the screenshot.
The problem is that it includes the time in the excel file. And somehow the date gets reduced by one day and gets the (selected date-1) day and the 22:00 or 00:00.
Does anybody know how to fix that?
I tried this:
The time is still included as you can see...
答案1
得分: 1
因为您的图片显示的是德文文本，我推断问题的原因是您的应用程序和Excel数据源对时间的解释不同（您的中欧时间转换为了协调世界时）。
我建议您观看Shane的这段视频，他解释了PowerApps如何与Excel配合以及您可以采取哪些措施来应对此行为。
英文:
Since your picture shows German text, I assume the cause of the issue is that your app and your Excel datasource are interpreting time differently (your CET time was converted into UTC).
I recommend you watch this video from Shane where explains how PowerApps works with Excel and what you can do to counter this behaviour.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论