[2005] query problem

[Ecniv]

d1 = Format(d1,"dd/mm/yyyy")
b = "SELECT STTM_CUSTOMER.CUSTOMER_NAME1, STTM_CUST_ACCOUNT.CUST_AC_NO, STTM_CUST_ACCOUNT.ADDRESS1, STTM_CUST_ACCOUNT.ADDRESS2, STTM_CUST_ACCOUNT.ADDRESS3, STTM_CUST_ACCOUNT.ADDRESS4, STTM_CUST_PERSONAL.TELEPHONE, STTM_CUST_PERSONAL.FAX, STTM_CUSTOMER.COUNTRY, STTM_CUST_PERSONAL.E_MAIL FROM STTM_CUST_ACCOUNT, STTM_CUSTOMER, STTM_CUST_PERSONAL WHERE STTM_CUST_ACCOUNT.CUST_NO = STTM_CUSTOMER.CUSTOMER_NO AND STTM_CUSTOMER.CUSTOMER_NO = STTM_CUST_PERSONAL.CUSTOMER_NO AND trunc(STTM_CUSTOMER.CHECKER_DT_STAMP) = '" & d1 & "'"

Might work...

[LinXG]

I think I spotted the problem and also discovered you are using VB.Net.

d1 is dimensioned as System.DateTime and VB.Net doesn't like this statement.

d1 = Format(d1,"dd/mm/yyyy")

Try this change

Dim d1 As System.DateTime = System.DateTime.Today
Dim d2 As String
d2 = Format(d1, "dd/MM/yyyy 12:00:00")

b = "....... your SQL statement ... = '" & d2 & "'"