jw
|
| Posted: 06/20/2002, 8:21 AM |
|
What is the correct format for getting the current date into sql for a grid
I am using this and it keeps erroring out
SELECT szCompany, szPriority, szStatus, lTaskID, tblTask.szUserID AS
tblTask_szUserID, dtDue, szTask
FROM (((tblTask INNER JOIN tblCompany ON tblTask.lCompanyID =
tblCompany.lCompanyID) INNER JOIN tblPriority ON tblTask.lPriorityID =
tblPriority.lPriorityID) INNER JOIN tblStatus ON tblTask.lStatusID =
tblStatus.lStatusID) INNER JOIN tblTaskType ON tblTask.lTaskTypeID =
tblTaskType.lTaskTypeID
WHERE tblStatus.lStatusID = {0} AND lUserID = {UserID} AND ( dtDue = Date)
ORDER BY dtDue desc
|
|
|
 |
|
