日期在两个日期之间

问题描述:

我在这里有些空白,希望能有所帮助!

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/开发自己的工作流程的分步指南

谢谢

温迪