Kourosh Barati
asked on
Classic ASP date query question
Hi,
I have a query to display simple information on an classic ASP page. What I need is the part it filters the "emp_term_date" to be greater than today's date. I want the system to automatically grab today's date and replace the '6/11/2015' in the query. Here is my query:
Select
informix.sfu_localdirect_r ec.id,
informix.sfu_localdirect_r ec.staff,
informix.sfu_localdirect_r ec.stu,
Trim(informix.sfu_localdir ect_rec.fu llname) As fullname,
Trim(informix.sfu_localdir ect_rec.em ail) As email,
Trim(informix.sfu_localdir ect_rec.ln ame) As lname,
Trim(informix.sfu_localdir ect_rec.fn ame) As fname,
informix.sfu_localdirect_r ec.rec_typ e,
informix.sfu_localdirect_r ec.emp_ter m_date
From
informix.sfu_localdirect_r ec
Where
(informix.sfu_localdirect_ rec.rec_ty pe <> 'P' And
informix.sfu_localdirect_r ec.emp_ter m_date Is Null) Or
(informix.sfu_localdirect_ rec.emp_te rm_date > '1/11/2015' )
Order By
lname
I have a query to display simple information on an classic ASP page. What I need is the part it filters the "emp_term_date" to be greater than today's date. I want the system to automatically grab today's date and replace the '6/11/2015' in the query. Here is my query:
Select
informix.sfu_localdirect_r
informix.sfu_localdirect_r
informix.sfu_localdirect_r
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
informix.sfu_localdirect_r
informix.sfu_localdirect_r
From
informix.sfu_localdirect_r
Where
(informix.sfu_localdirect_
informix.sfu_localdirect_r
(informix.sfu_localdirect_
Order By
lname
ASKER
I am using informix odbc connection and using that function it gives me "routine getdate() can not be resolved.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If I use '6/11/2015' then it works. It seems converting date to string might work?
ASKER
Current worked well. Thanks
glad to help :)
Select
informix.sfu_localdirect_r
informix.sfu_localdirect_r
informix.sfu_localdirect_r
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
Trim(informix.sfu_localdir
informix.sfu_localdirect_r
informix.sfu_localdirect_r
From
informix.sfu_localdirect_r
Where
(informix.sfu_localdirect_
informix.sfu_localdirect_r
(informix.sfu_localdirect_
Order By
lname