How to get the interval number of days leaped between the two date using SQL Statement in VB6 ??
currently i used ADODC Data Control in my project..
i had tried several SQL Date Built-In Function found in w3schools.com but still useless
such not functioning code is ..
Dim dTglNow As Date Dim commSQL As String dTglNow = CDate( Format(Now,"dd-mmm-yy") ) commSQL = "SELECT ID_BUKU, JUDUL_BUKU, TGL_PINJAM, DATEDIFF(dd," & CStr(dTglNow) _ &",TGL_PINJAM) AS [SELANG HARI] FROM PINJAM" AdocData1.RecordSource = commSQL AdocData1.Refresh
Finally its viewed the ERROR MESSAGE As : wrong number of arguments used with function in query expression 'DATEDIFF(23-11-10,TGL_PINJAM)'
<please .. urgently requiring the answer >