Hi
No need of using # just do ,
date2=cadte(date1)
insert into abc(date1) values ('"& date2 &"')
manoj150283 <[EMAIL PROTECTED]> wrote:
i want to insert empty/null date in Ms-Access database using ASP.
The datatype of date filed is date/time in Access Database and the
code i am using to insert in database is as
<%
--------------
-----------------
insert into abc (date1) values (#" & date1 & "#)
%>
Please help me so that i can insert empty/null date in ms-access
database.
SPONSORED LINKS
Basic programming language Computer programming languages
Programming languages Java programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspClassicAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Jegatha
" He will cover you with his feathers,and under his wings you will find
refuge;
his faithfulness will be your shield and rampart "
---------------------------------
Enjoy this Diwali with Y! India Click here
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/