小组如何约会到最小组 [英] how group dates to min groups
问题描述
让我挑战你
i有日期间隔列表
我正在寻找创造性的方式将它们分组到最小间隔
(列表中没有重叠)
例如:
14/08 / 2016-15 / 08/2016
16/08 / 2016-16 / 08/2016
23/08 / 2016-24 / 08/2016
25/08 / 2016-26 / 08/2016
====>>>
14 / 08 / 2016-16 / 08/2016
23/08 / 2016-26 / 08/2016
谢谢!!!
Let me challenge you
i have list with dates interval
i''m looking for creative way to group them to minimum intervals
(there is not overlap in the list)
example:
14/08/2016-15/08/2016
16/08/2016-16/08/2016
23/08/2016-24/08/2016
25/08/2016-26/08/2016
====>>>
14/08/2016-16/08/2016
23/08/2016-26/08/2016
thanks!!!
推荐答案
ben1988
我们要求您告诉/告诉我们您已尝试过的内容。通过提供这些信息,您可以帮助我们帮助您不要过去已经尝试过的内容,它会让我们了解您的经验水平。
此外,您不需要向我们提供有关您的数据库或数据集的任何详细信息。如果没有这些信息,可能会有许多潜在的解决方案。请点击常见问题解答部分,查看如何提问。 section。
ben1988
We do ask that you tell/show us what you''ve already tried. By providing this information you help us to help you by not going over what you''ve already tried and it gives us an idea of your level of experience.
Also, you do not provide us with any details about your database nor dataset. Without that information there could be dozens of potential solutions. Please click on the FAQ section and review the "how to ask questions" section.
我刚开始第一条记录(1)
保存结束日期
转到第二条记录(2)
询问此记录的开头是否减去前一记录(1)= 1
如果是 - 结束(1)=结束(2)
和最后一样...
i just start with the first record (1)
save the end date
go to second record (2)
ask if the start of this record minus previous end record (1) =1
if yes - the end (1)=end(2)
and last like it...
所以我们现在得到结果,并且有一个非常稀疏的解释;但是,我们没有任何示例原始数据。
原始数据实际上无法从您的示例结果中猜到。在一个案例中,日期之间没有(0)跨度,
So we now have the result, and a very sparse explanation; however, we do not have any example raw data.
The raw data really cannot be guessed at from your example result. In one case you have no (0) span between dates,
16/08 / 2016-16 / 08/2016
16/08/2016-16/08/2016
下一套你有两到三天的日期
the next sets you have two or three days between dates
14/08 / 2016-16 / 08/2016
23/08 / 2016-26 / 08/2016
14/08/2016-16/08/2016
23/08/2016-26/08/2016
各组之间是否有任何关系,2016年8月16日如何与23/08相关/ 2016上面?
另外要记住的是,你正在使用DD / MM / YY格式,ACC有一些可能出现的怪癖,特别是如果你使用的是VBA
阅读此处:访问中的国际日期
这篇关于小组如何约会到最小组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!