By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,994 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,994 IT Pros & Developers. It's quick & easy.

apply filter for date variable

P: 25
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
Mar 16 '09 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,287
Do you mean you have two text boxes, one for start and one for finish?
You would need to set the filter to:
Expand|Select|Wrap|Line Numbers
  1. "TransactionDate BETWEEN #" & start & "# AND #" & finish & "#"
Mar 16 '09 #2

P: 25
yes....that's what i mean
thank you.it works
Mar 17 '09 #3

NeoPa
Expert Mod 15k+
P: 31,760
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 (#).
Apr 4 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.