How to display records of any table between two Entered dates

SQL qery for display all records between two entered dates.

[mp3mechanical]

Hi geeks,
i am working on a prject with asp & access database.
project is 99% completed but i have a problem of displaying table data from database for all dates betweeen two dates enterd by user.
i.e. user want to display records from 12 november 2005(11/12/2005) to 27 november 2005(11/27/2005).he picks up date by datetimepicker popup & then submit form.

i have tried loops, trgiggers etc for date in two ways by javascript & SQL but they are not working either.

PlLease Help me i have deadline to finish project very soon.

Thank You.

[saugata_roy]

u can try converting the date value before quering and comparing the database. for example in sql server u can use

select * from table1 where convert('datetime',datecolumn)>convert('datetime',mydate1) and convert('datetime',datecolumn)<convert('datetime',mydate2)

[mp3mechanical]

i am using access database & dont have sql server on my host.
please tell me about the sql query or change needed inthe database.

thank you.

[saugata_roy]

use the cdate() function, e.g.

SELECT datecreated, name
FROM Table1 where cdate(datecreated)>cdate('10 august 2005') and cdate(datecreated)<cdate('10 november 2005');

[carguy84]

does dateDiff() not work in Access?

[saugata_roy]

oh yeah... i forgot abt tht. dateDiff() function also works fine