can tell me wat's wrong?

VB Code:

invdate <= #" & cboTdate & " # and invdate >= #" & cboFdate & " #

both cboTdate and cbdFdate are combo boxes that contain date values..

the thing is, when cboTdate is 1-Apr-2002 and cboFdate is 20-Apr-2002, the output is correct ..

but if cboFdate is 30-Mar-2002 and cboTdate is 20-Apr-2002, nothing comes out.. is my code wrong? :(

Your code is confusing to me...could you give us the whole line. What you had is just one big syntax error...

hai

about your date problem

convert the date into

clng(cdate(invdate) <= clng(cdate(cbotdate) .......

try this one


with regards
gopi

Quote:

---

Originally posted by The Hobo
Your code is confusing to me...could you give us the whole line. What you had is just one big syntax error...

---

.Open "SELECT * from internal where procode = '" & cmbProd.Text & "' and bracode = '" & cmbSup.Text & "' and invdate <= #" & cmbTdate & " # and invdate >= #" & cmbFdate & " # order by type, invdate", conn, adOpenForwardOnly, adLockReadOnly

Just my two cents. I think it is much, much easier to use BETWEEN than to use to equality operators.

This finds everything inclusive of the two dates:

WHERE Date BETWEEN Date1 AND Date2

This finds everything outside the two dates:

WHERE Date NOT BETWEEN Date1 AND Date2

Quote:

---

Originally posted by fujin


it doesn't work .. sob sob :(

---

VB Code:

.Open "SELECT * from internal where clng(cdate(invdate)) <= clng(cdate(#" & cmbTdate & "#)) and clng(cdate(invdate)) >= clng(cdate(#" & cmbFdate & "#)) order by type, invdate", conn, adOpenForwardOnly, adLockReadOnly

Is that a "yes, it's working?"

Quote:

---

Originally posted by mendhak
Is that a "yes, it's working?"

---

nope, it doesn't

Quote:

---

Originally posted by fujin

VB Code:

.Open "SELECT * from internal where invdate <= " & clng(cdate(cmbTdate)) & " AND invdate >= " & clng(cdate(cmbFdate)) & " order by type, invdate", conn, adOpenForwardOnly, adLockReadOnly

---

now?

Quote:

---

Originally posted by mendhak


now?

---

nope.. btw, my date format is dd-mmm-yyyy .. does it make any diff?

for 10-Mar-2002 and 15-Apr-2002 , it works

but for 15-Mar-2002 and 10-Apr-2002, it doesn't

thank thanks.. work already... my database had some fault.. eheh sorry2..

Hallelujah! Praise the lord!

Thry this to if your prog works writh with these data
date1 "1/04/2002"
date2 "9/04/2002"

my prog fails when the days are smaller than 10.

if it works on your prog
please let me now