Sharepoint&信息日期查询 [英] Sharepoint & Infopath date query

问题描述

您好我正在制定一个培训预订系统（按照Sharepoint 2010创建和实施真实世界项目一书中的步骤）。

一切都没问题。 systrem具有SP列表，其具有作为日期/时间列的开始和结束列。如果我直接在列表中输入新课程，则会按预期格式显示开始日期。我正在尝试创建的表单通过数据连接使用此字段，以便我可以使用规则过滤课程，例如''start< now（）''显示/隐藏过去的课程。

无论我尝试什么我都无法让它工作。作为进一步的测试，我还在表单中添加了一个计算字段控件，此控件查看sharepoint列表中的字段，但其输出以错误的格式返回。我猜这就是为什么我的滤镜无法正常工作，但我无法解决原因。


任何想法都非常感激，因为这让我很生气。

Hi I am wrting a Training booking system(following the steps in the book Sharepoint 2010 creating and implementing real world projects).
All is ok apart from one thing. The systrem has a SP list that has start & end columns that are date/time columns. If i enter a new course directly into the list, then it shows the start date in the format as expected. The Form that i am then trying to create uses this field via a data connection so that i can filter the courses using a rule for example ''start < now()'' to show/hide course that are from the past.
No mater what i try i cannot get this to work. As a further test i have also added a calculated field control to the form, this control looking at the field in the sharepoint list, but the output of that comes back in the wrong format. I m guessing that this is the reason why my filter doesnt work, but i cant work out why.

Any ideas are really appreciated as this is driving me mad.

推荐答案

InfoPath表单使用xml来存储数据并仅以yyyy-MM-dd格式理解日期。日期控件属性具有格式按钮，可用于以特定格式显示日期。现在，如果您在DataSource中从InfoPath表单中唱出日期，则必须重新格式化它。尝试以yyyy-MM-dd格式编写过滤器并检查您的逻辑是否有效。

InfoPath form uses xml to store data and understands date in "yyyy-MM-dd" format only. The date control properties have format button which can be used to display the date in a specific format. Now if you are sing a date from InfoPath form in a DataSource you will have to re-format it. Try writing your filters in "yyyy-MM-dd" format and check if your logic works.

这篇关于Sharepoint&amp;信息日期查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！