Help with a query please

[toby007]

Hi there

I am using MySQL.

I have created a query but I am not getting any rows returned from running the
query. I think it has something to do with the date(s).

select R.*, GR.*
from Roster as R
Inner Join Girls_roster as GR
on R.RosterId = GR.Rosterid
where GR.Girlid = #URL.GirlID# AND
RosterDate Between #CreateODBCDate(LSDateFormat (weekstartdate,
"dd/mm/yyyy"))# AND #CreateODBCDate(LSDateFormat (weekenddate, "dd/mm/yyyy"))#

Basically in the roster file I havethe rosterdate. I want to select records
for a particular person that fall between a startdate and the enddate.

Thanks in advance for assistance.

Regards

[toby007]

I have worked out the problem is with the checking of the dates - but I still havent figured out exactly how to solve the issue. Any ideas?

[The ScareCrow]

Have not had a chance to look at your other problem yet, hopefully tonight.

But with this do not use dateformat when passing a date to an sql statement, just use createodbcdate

Ken