How to insert a record and to retrive records between two dates for MS Access

[PerumalSamy]

Hi,

i am doing program in asp.net using vb coding and MS Access as back end.

i am having a table with date field and manipulation is based on the same.

i am inserting value from textbox using sql query as follows

ex: Textbox1.text="10-04-2007" (ie. in dd-MM-yyyy format)

dim dat as date = Textbox1.text
Insert into tablename (datefield,others) values ('" & dat & "','" & textbox2.text & "')",con)

datefield in my database is date/time ( short date)

while retriving records between two dates as per below query, i am not getting the result

select * from tablename where datefield<=#'' & textbox3.text & "'# and datefield=#'' & textbox4.text & "'#

any idea

[kenobewan]

I believe that your query is still reading your dates as text. HTH.

[PerumalSamy]

Sorry, I cant get you

[PerumalSamy]

Even the following query is also not working.

dim fromdate as date=format(cdate(textbox3.text),"MM-dd-yyyy")
dim todate as date=format(cdate(textbox4.text ),"MM-dd-yyyy")

select * from tablename where cdate(datefield)<=#'' & fromdate & "'# and datefield>=#'' & todate & "'#

The above coding is working in my system. But while uploading in server, i am getting error as "cast from string "30/4/2007" to type "date" is not valid

[myrrdin]

Try using the Access Date method in your query

select * from tablename where datefield<=Date('' & textbox3.text & "')"