Date comparison in SQL function

[davidmulcair]

Here's a snippet:

SELECT tblLoans.LoanNum,
tblLoans.UserNum,
tblUsers.FirstName,
tblUsers.LastName,
tblLoans.LoanStatusCode,
tblLoans.LoanIssueDate,
tblLoans.LoanDueDate
FROM tblUsers INNER JOIN tblLoans ON tblUsers.UserNum = tblLoans.UserNum;

I want to add a WHERE clause to specify all of the "Loans" that are past the due date. I don't know how to get Access to retreive today's date in order to do this comparison.

Help please.

David Mulcair

 

[SIG357]

You can use the function Now() to return the present Date/Time for comparison. So your criteria would be something like
WHERE tblLoans.DueDate < Now()

Hope that's what you're looking for

 

[tlbroadbent]

Use the Date() function.

SELECT tblLoans.LoanNum,
tblLoans.UserNum,
tblUsers.FirstName,
tblUsers.LastName,
tblLoans.LoanStatusCode,
tblLoans.LoanIssueDate,
tblLoans.LoanDueDate
FROM tblUsers INNER JOIN tblLoans ON tblUsers.UserNum = tblLoans.UserNum;
WHERE tblLoans.LoanDueDate<date(); Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin

 

[davidmulcair]

Thanks. It works.