eyeshield21
Programmer
how can i use the date and time picher for filtering date?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date and Time picker for search
- Thread starter eyeshield21
- Start date
- Status
vgulielmus
Programmer
From my memory, I believe you have to use the _value property
Respectfully,
Vilhelm-Ion Praisach
Resita, Romania
Respectfully,
Vilhelm-Ion Praisach
Resita, Romania
Olaf Doschke
Programmer
Which one are you using? MS ActiveX Datetime Picker? Activate Window Calendar? Something else?
The question is a two part question, lets assume you have a date in ldFilterdate, then filtering data with it can be done by
SET FILTER TO Field = m.ldFilterdate
or
SELECT * from table where Field = m.ldFilterdate
and many more ways, eg using BETWEEN SQL Clause, BETWEEN() function...
Bye, Olaf.
The question is a two part question, lets assume you have a date in ldFilterdate, then filtering data with it can be done by
SET FILTER TO Field = m.ldFilterdate
or
SELECT * from table where Field = m.ldFilterdate
and many more ways, eg using BETWEEN SQL Clause, BETWEEN() function...
Bye, Olaf.
- Thread starter
- #4
- Status
Similar threads