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 ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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/
