apply filter for date variable

[dbdb]

hi guys

need your suggestion
how can i apply filter for my date variable data type

i have a form name transaction
and i have a text box on it named : start and finish

i need to apply filter my data using that 2 data.
i have to view data for the transaction date between start and finish date.

i used the command button to proceed it filter.

can u help me guys...

thanks anyway

[ChipR]

Do you mean you have two text boxes, one for start and one for finish?
You would need to set the filter to:

"TransactionDate BETWEEN #" & start & "# AND #" & finish & "#"

[dbdb]

yes....that's what i mean
thank you.it works

[NeoPa]

For locations outside the US it's also helpful to remember that the standard format for dates in SQL is NOT location dependent. See Literal DateTimes and Their Delimiters (#).