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...