Parameter query in visual basic

[osi2301]

Is there any way to write query a date range in visual basic? I have a date range from thats called beginning date and ending date. I want to be able to determine if a specified date falls within the date range. Is there any way to do this in visual basic. Can BETWEEN be used in VB just as its used in a query? I have tried this expression but of course it doesn't work:
if [leavestart] = between [beginningdate] and [endingdate]then.
I know this doesn't work but its an example of what I would like to accomplish.

 

[TheAceMan1]

How are ya osi2301 . . .

[blue]Is there any way to write query a date range in visual basic?[/blue]

Not to my knowledge . . . but there is the forever known:

[blue]   If ([leavestart]>=[beginningdate]) And ([leavestart]<= endingdate]) Then[/blue]

See Ya! . . . . . .

 

[osi2301]

Ok, thanks. I already had that coded. I just wasn't sure if another simplier method may have been available.

Thank You