Are you calling a stored procedure? Do you mean you don't know what type of parameter you should define it as?
I always use adDate If that's not what you're talking about, you might need to explain a little further. Chris Tifer http://www.emailajoke.com ----- Original Message ----- From: "Dylan Barber" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 5:45 AM Subject: SQL and dates in a page I have a news script that inserts a news item into a database (MS SQL server 2000) the table has a release date field that I want to check against the current date. Sounds simple right. However I can not figure out how to submit a datetime to the Database so Right now I can't check the date can anybody help me? __________________________________________________ Dylan Barber (CIW Professional, A+ Technician) Programmer/Analyst DPRA Inc. phone (785) 539-3565 ext.1034 e-mail [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
