Searching between 2 Date Values using vb sql

[Benna]

I’m using VB.06 program.

I am trying to do a check details between 2 date values records stored inside database are only start date and end date.

For example, I’m searching between 2 datetime
Startdate = “2/01/2012”("dd/MM/yyyy")
Enddate = “06/01/2012”

Thanks in advance

[ck9663]

Check the BETWEEN operator.


Happy Coding!!!


~~ CK

[Benna]

I used "BETWEEN" operator.it only assign value for the saved date in the database.i have to check the in between date which is not saved in the database

[Alfredo194]

U need to use operations !
like this :

StartTime >= '08:00:00' and EndTime <= '16:00:00'

good lock