wayneseymour
New Member
- Joined
- Dec 7, 2016
- Messages
- 7
I have an advanced filter that runs on my Excel VBA application which is suppose to filter dates in the data base, I created the advance filter on the worksheet and it works fine except for when it comes to filtering dates this is the formula I'm using:
=IF(C5="",">1","<=" &C5) start date
=IF(C5="","<60000","<" &C5) end date
I tried removing the Quotes from the <60000 but received a error.
the filter will not filter the dates requested.
For example I ask to filter date between 9/20/2018 and 9/30/2018 I get results outside those dates as well as the dates requested.
another example ,If I ask for dates of say 5/1/2016 and 5/30/2016 I get dates from 4/1/2016 as well. I I ask for all records with the date of 9/29/2018 I get nothing. Another weird on is if I ask for 5/1/2016 I get 4/30/2016
=IF(C5="",">1","<=" &C5) start date
=IF(C5="","<60000","<" &C5) end date
I tried removing the Quotes from the <60000 but received a error.
the filter will not filter the dates requested.
For example I ask to filter date between 9/20/2018 and 9/30/2018 I get results outside those dates as well as the dates requested.
another example ,If I ask for dates of say 5/1/2016 and 5/30/2016 I get dates from 4/1/2016 as well. I I ask for all records with the date of 9/29/2018 I get nothing. Another weird on is if I ask for 5/1/2016 I get 4/30/2016
