Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Query for date

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorjustnajm
    • CommentTimeNov 29th 2006
     
    Hi,

    I have 'reservation' table in the MS Acess Database and I want to retrieve the records on the basis of 'checkin' date and 'checkout' date, the query is:


    SELECT * FROM reservation WHERE check-in >= '08/08/06' AND check-out <= '08/09/06'


    But as I run this query from my asp page, it gives me the type mismatch error, this far I know that date type behaves as string when written in queries. But whats the problem here, please some body help me, is there any mistake in the query as I have tried it with lots of method but date queries are not running.

    Thanks.
    • CommentAuthorjustnajm
    • CommentTimeDec 19th 2006
     
    After all I have learned this too, the real code for this query, performed on MS Acess database is like this:


    SELECT * FROM reservation WHERE check-in >= '%08/08/06%' AND check-out <= '%08/09/06%'


    Amazing is'nt it, that MS Acess identifies the dates in the above form, date between percent signs.

1 to 2 of 2

  1.