date query problem inplementation in vb.net
-
Sir/Madam, I am facing the date query problem .Actually , I am using the following query to get the records which are present in between two dates. select * from table where field between 12/12/2000 and 10/1/2001 * Field is the date type in the database. Please help. Thanks and Regards Pankaj
-
Sir/Madam, I am facing the date query problem .Actually , I am using the following query to get the records which are present in between two dates. select * from table where field between 12/12/2000 and 10/1/2001 * Field is the date type in the database. Please help. Thanks and Regards Pankaj
I don't understand what your problem is. What is it you are having a problem with? My only advise is that you should use ISO format dates because there are culture neutral.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Sir/Madam, I am facing the date query problem .Actually , I am using the following query to get the records which are present in between two dates. select * from table where field between 12/12/2000 and 10/1/2001 * Field is the date type in the database. Please help. Thanks and Regards Pankaj
-
If I've correctly understood your question, I think you should use following structures: select * from table WHERE field >=#12/12/2000# And field <=#10/1/2001# or select * from table WHERE field Between #2000/12/12# And #2001/10/01#
-
Thanks You Sir.Thanks for ur kind attention.problem is solved .Ur query is working. Can , I send the mail programically in vb.net (Window Application). If possible please send a sample code link. Thanks and Regards Pankaj