Getting dates for SQL not working

[jctaylor]

I am creating a new database program in access similar to the one I had in Visual Foxpro(it is currently still being used). I periodically update the tables with new data from the old program. I export the tables to excel and import them into Access. I have some reports based on SQL statements that get the starting and ending date using functions. I was working fine until my last data update. Now all of a sudden when I put in the beginning and ending dates, it returns no records. I have tried just putting in the dates using #date# and that doesn't work. I have checked the table and it is a date field. I must be missing something, but I don't know what. Does anybody have any ideas what could cause this to happen?

[Perceptus]

Do you have the SQL code for the underlying query?

[jctaylor]

SELECT ar.client, Customer.Custname, ar.ttyp, ar.inv_date, ar.inv_no, ar.inv_amt, ar.payment, ar.balance
FROM ar INNER JOIN Customer ON ar.client = Customer.custid
WHERE (((ar.client)>=GetBegCustId() And (ar.client)<=GetEndCustId()) AND ((ar.ttyp)="IN") AND ((ar.inv_date)>=GetBegRptDate() And (ar.inv_date)<=GetEndRptDate()))
ORDER BY ar.inv_date;

[Perceptus]

I would recommend trying the between operator. I may have the number of Parenthesis off. but I think this gives the gist.

SELECT ar.client, Customer.Custname, ar.ttyp, ar.inv_date, ar.inv_no, ar.inv_amt, ar.payment, ar.balance
FROM ar INNER JOIN Customer ON ar.client = Customer.custid
WHERE (((ar.client)>=GetBegCustId() And (ar.client)<=GetEndCustId()) AND ((ar.ttyp)="IN") AND (ar.inv_date Betweeen GetBegRptDate()  And GetEndRptDate())
ORDER BY ar.inv_date;

[jctaylor]

I tried this: SELECT ar.client, Customer.Custname, ar.inv_date, ar.ttyp, ar.inv_no, ar.inv_amt, ar.refer, ar.payment, ar.balanceFROM ar INNER JOIN Customer ON ar.client = Customer.custid
WHERE (((ar.client)>=GetBegCustId() And (ar.client)<=GetEndCustId()) AND ((ar.inv_date) Between GetBegRptDate() And GetEndRptDate()) AND ((ar.ttyp)="IN"));

It didn't work either.

[jctaylor]

I went back and imported my data again and now it works. It must have been something wrong with the table. Thanks for your input!