Code Help

[tekyge]

The below code works but it shows all the records or none, and I would like it to show only the records after the current date. Any help?

sql = "SELECT * FROM [Projects] WHERE [Projects].[ActID]=" &Trim(session("myvar1"))& " AND [Projects].[CDate]>Date()" & " ORDER BY [Projects].[ProjectName] ASC

 

[PHV]

You may try this:
sql = "SELECT * FROM Projects WHERE ActID=" & Trim(Session("myvar1")) & " AND Int(CDate)>Int(Date()) ORDER BY ProjectName"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tekyge]

Thanks it worked great