can tell me wat's wrong?

[fujin]

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?

[The Hobo]

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

[dgopi_27]

hai

about your date problem

convert the date into

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

try this one


with regards
gopi

[fujin]

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

[cafeenman]

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

[fujin]

Originally posted by fujin


it doesn't work .. sob sob

.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

[mendhak]

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

[fujin]

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

nope, it doesn't

[mendhak]

Originally posted by fujin

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

now?

[fujin]

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

[fujin]

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

[mendhak]

Hallelujah! Praise the lord!

[Heribertt]

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