请求离开日期“窗口”？ [英] Help with Leave Date "window"?
问题描述
我还在为我的单位开发DataBase，我需要找到一种方法输入两个日期[startdate] [enddate]并让这些日期保持它们之间的时间值。说我在2007年1月1日和2007年1月1日进入。然后在2007年6月1日做了一个日期服务2007年10月1日，我希望上面的开始/结束日期出现，因为它们正在serch时间框架内发生。希望这是可以理解的，我有点困惑自己。继承了我此时正在使用的代码。
I''m still working on a DataBase for my unit and I need to find a way to enter in two dates [startdate] [enddate] and have those dates hold the value of the time between them. say i enter in 01/01/2007 and 02/01/2007. and then do a date serch for 01/06/2007 threw 01/10/2007, I want the above start/end date to show up, because they are happening durring the serch timeframe. Hope this is understandable, I''m sorta confusing myself. heres the code I''m using at this time.
推荐答案
试试这个......
Try this ...
感谢代码，但我没有运气。 Sorta得到的结果与我得到的结果相同。我想也许我的问题不在代码中，但可能在其他方面。我需要找到一种方法让我的日期范围保持在范围内的每日价值，所以如果我看一下范围中间的一天，它会告诉我这个人在那个时候休假。现在我只能获得从我的搜索范围开始的日期。我真的非常感谢你的帮助。我想也许我刚开始从联盟中脱颖而出。大声笑..
Thanks for the Codes, but I didn''t have any luck with them. Sorta got the same results that I''d been getting. I think maybe my problem isn''t in the Code, but maybe in something else. I need to find a way to make my date range hold the value of everyday in the range so if i look at a day in the middle of the range it will tell me that this person is on leave durring that time. Right now I can only get dates that start in my search range. I do really thank you for your help though. I think maybe I''m just starting to get a bit out of my league. lol..
试试这个...
Try this ...
感谢代码，但我没有运气。 Sorta得到的结果与我得到的结果相同。我想也许我的问题不在代码中，但可能在其他方面。我需要找到一种方法让我的日期范围保持在范围内的每日价值，所以如果我看一下范围中间的一天，它会告诉我这个人在那个时候休假。现在我只能获得从我的搜索范围开始的日期。我真的非常感谢你的帮助。我想也许我刚开始从联盟中脱颖而出。 lol ..
Thanks for the Codes, but I didn''t have any luck with them. Sorta got the same results that I''d been getting. I think maybe my problem isn''t in the Code, but maybe in something else. I need to find a way to make my date range hold the value of everyday in the range so if i look at a day in the middle of the range it will tell me that this person is on leave durring that time. Right now I can only get dates that start in my search range. I do really thank you for your help though. I think maybe I''m just starting to get a bit out of my league. lol..
您的表结构是什么以及如何记录这些数据？
What''s your table structures and how is this data recorded?
这篇关于请求离开日期“窗口”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
