如何查找超过1个月的数据? [英] How to find data between more than 1 month?

问题描述

我想查找1个月以上的数据.

我有一个表单，我有两个datepicker控件，我想按月搜索这两个日期之间的数据.

例如:
我选择2012年12月8日和2012年12月30日，然后我要全部记录的金额为

12/08/2012 500
12/09/2012 1000
2012年1月10日100
2012年5月11日200
2012年12月28日150



预先感谢.

Hi I want to find the data which are in between more than 1 months .

I have one form i have two datepicker control I want to search data between those two dates but monthwise.

example:
I select 12/08/2012 and 30/12/2012 then i want to all record with amount like

12/08/2012 500
12/09/2012 1000
01/10/2012 100
05/11/2012 200
28/12/2012 150



thanks in advance.

推荐答案

考虑要计算多少个月并不重要.考虑两个日期之间的差异很重要然后，我有一个问题要问，您是否在这段时间内从数据库中搜索数据?然后您将需要查询以检索这些值.如果为true，则请通知我.但是，这里有一些链接可以计算日期差..
http://www.go4expert.com/forums/showthread.php?t=3609 [ ^ ]
http://msdn.microsoft.com/en-us/library/b5xbyt6f％28v = vs.80％29.aspx [ ^ ]
http://www.dotnetspider.com/resources/458-How-find-difference-between-two-Dates-C-or.aspx [

It''s not important to consider how many months you need to calculate..it''s important to consider the difference between two dates.Then i have one question to you,do you search your data from a database within this time?Then you will need query to retrieve those values.If it true,then let me know.However,here are some links to calculate date difference..
http://www.go4expert.com/forums/showthread.php?t=3609[^]
http://msdn.microsoft.com/en-us/library/b5xbyt6f%28v=vs.80%29.aspx[^]
http://www.dotnetspider.com/resources/458-How-find-difference-between-two-Dates-C-or.aspx[^]

这篇关于如何查找超过1个月的数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！