在访问数据库中按今天过滤日期 [英] Filter By Today Date in access database

问题描述

Hi I have an access database and in database i create Three Table First Table Name Is Attandance, Second is Template And Third is Absent i want to filter which data not in Attandance filter by Only Today Date from Template table and i don't want old dated User ID and Insert in Absent Table

Table Details

Attandance Field = TemplateID(AutoNumber), UserID(Number),State(Text),Att_Date(Date/Time)

Template Field = TemplateID(AutoNumber),UserID(Number),Full_Name(Te xt),Age(Number)

Absent Field = TemplateID(AutoNumber), UserID(Number),State(Text),Att_Date(Date/Time)

我的编码如下但是它不工作

my Coding as under but its its not working

string[] mylist = new string[3000];
int i = 0;

str = "select a.*,b.* from Template a, Attandance b where a.UserID=b.UserID and ATT_Date="+mydate+"";//order by ATT_Date desc
cmd = new OleDbCommand(str, conn);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
    String ddate = dr[14].ToString().Substring(0, dr[14].ToString().Length - 11).Trim();
    if (ddate.Trim().Equals(mydate.Trim()) == false)
    {
        mylist[i] = dr[1].ToString();
        i++;
        dt.Rows.Add(dr[1].ToString(), dr[6].ToString(), dr[7].ToString() + dr[8].ToString(), dr[9].ToString(), dr[10].ToString(), ddate);
    }

}
dr.Close();

推荐答案

select * from
Attandence 
Where 
date(Att_Date)>=cdate('2013-09-23')

Happy Coding！

：）

Happy Coding!
:)

看到这个..

http://bytes.com/topic/access/answers/916085-how-filter-current-date-query [ ^ ]

See this..
http://bytes.com/topic/access/answers/916085-how-filter-current-date-query[^]

这篇关于在访问数据库中按今天过滤日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！