-------Original Message-------
From: [EMAIL PROTECTED]
Date: Tuesday, August 24, 2004 13:51:51
To: [EMAIL PROTECTED]
Subject: RE: [ASP] pls exp about Ms access Casting
If it's in access I believe you want to use the cDate function, and surround
your dates with #s not apostrophes. Something like this should work :-
select * from table_name where cDate([Date]) between #1/1/2004# and
#12/12/2004#;
My access is a little rusty, so you might have to play around with that.
Dan
www.diado.com
-----Original Message-----
From: Waqar [mailto:[EMAIL PROTECTED]
Sent: 24 August 2004 08:51
To: [EMAIL PROTECTED]
Subject: [ASP] pls exp about Ms access Casting
hi,
my problem is that:
how i convert text date into dete
format
my code :
sql= "select * from table_name where date between
1/1/2004' and '12/12/2004' "
Date fielt in database is text formet os it maket porblem how i
convert text into date format
i m using casting but is not wroking.
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> 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/
