how do you search for dates?

[AxeaXeaxE]

I have 3 lists of values, containing day, month and year. There are 3 possiblities: choose day and month and year, choose month and year or choose nothing. How do I search in a table for the records? I put them in "Keuzelijst"

I've got this, but it doesn't work properly:

If ChcDay.Value <> &quot;&quot; Then
day = KzeDag.Value & &quot;-&quot;
Else: day = &quot;&quot;
End If

month = ChcMonth.Value & &quot;-&quot;

year = ChcYear.Value

date = day & month & year

Keuzelijst.RowSource = &quot;select export2.id, export2.chauffeur, export2.kenteken, export2.schadenummer, export2.schadedatum, export2.klantnummer from export2 where &quot; & date & &quot; is export2.schadedatum&quot;

 

[SkipVought]

Hi,

I think that you want your Where Clause to state...

"where  export2.schadedatum = " & date & " "

Skip,
metzgsk@voughtaircraft.com

 

[AxeaXeaxE]

No, that's not quite what I mean. I want him to search for everything containing 04-2002 when a user only filled in month and year. That's the tricky part...

 

[SkipVought]

I thnk that in that case you'll need to build a Where Statement like this...

Where export2.schadedatum Between " & FromDate & " And " & ThruDate

where in your example, the FromDate is 01-04-2002 and ThruDate is 30-04-2002. Skip,
metzgsk@voughtaircraft.com

 

[AxeaXeaxE]

yes thanks! brilliant idea!