日期在两个日期之间
我在这里有些空白,希望能有所帮助!
I'm drawing a bit of a blank here and was hoping for some help!
我有两个列表:
列表A:会议详细信息,周开始日期,周结束日期
List A: Meeting details, week start date, week end date
列表B:许多其他列,然后是结束日期.
List B: Many other colums and then a closing date.
我想做的是检查列表B中的结束日期是否在列表A中的开始日期和结束日期之间:找到该日期所在的一周,然后将该周的会议详细信息"列中的信息放入列表B中的字段.
What I want to do is check if the closing date in List B is between a start and end date in list A: find the week it falls into and then put the info from the meeting details column for that week into a field in List B.
希望这很有道理!预先感谢!
Hope this makes sense! Thanks in advance!
D
迪尔,
根据您的描述,您想检查一个日期是否在两个日期之间.如果是,请将会议详细信息从列表A拉到列表B的字段中.
From your description, you want to check if a date is between two dates. If yes, pull the meeting details from List A into a field of List B. Is it right?
您可以为列表B创建SharePoint Designer 2010工作流,并使用如果条件"来比较日期,并且该条件与条件匹配,请使用更新列表项"更新列表B.
You can create a SharePoint Designer 2010 workflow for the list B and use If condition to compare the dates, and it matches the condition, use "Update List Item" to update List B.
关于使用SharePoint 2010 Designer创建工作流,您可以参考:
About creating a workflow using SharePoint 2010 Designer, you can refer to:
https://www.codeproject.com /Articles/125120/开发自己的工作流程的分步指南
谢谢
温迪