Problem In Date In sql Query
-
I am using MS Access 2003 with VB.Net 2003. In one of my Table A field(ResignDate) is of type
TextI am writing following query to retrieve the name and other information of employee who resigned before a specific date which is to be given in the condition..... my query is..Dim sql16 As String = "SELECT Employee_AutoID,NameInitial,NameInitial+' '+Name " & _ "AS Emp_Name,Designation FROM tblEmployeeMaster " & _ "WHERE Resign_Flag='No' OR CDate(ResignDate)< #" & endDayOFFinancialYear & "# "what is wrong in the query....Tirtha Miles to go before I sleep
-
I am using MS Access 2003 with VB.Net 2003. In one of my Table A field(ResignDate) is of type
TextI am writing following query to retrieve the name and other information of employee who resigned before a specific date which is to be given in the condition..... my query is..Dim sql16 As String = "SELECT Employee_AutoID,NameInitial,NameInitial+' '+Name " & _ "AS Emp_Name,Designation FROM tblEmployeeMaster " & _ "WHERE Resign_Flag='No' OR CDate(ResignDate)< #" & endDayOFFinancialYear & "# "what is wrong in the query....Tirtha Miles to go before I sleep
remove Cdate function resigndate='"+enddayofffinancialyear+"'