How To Code Dual Criteria For Filtering

[ScotyB]

Hi all,

so far, I've been able to get the first criteria to work, finding all the "Pending" items in the range, but I'm obviously not getting the syntax right with regards to the second criteria that filters dates.
Basically, I want the second criteria to filter so that it only shows dates between Today() and the 7 days previous.
Would someone be able to point me in the right direction with that?
Cheers,
AJ

Please Login or Register  to view this content.

[Crooza]

Try this syntax. Also note myDate doesn't equal today() but equals date (which will give you today's date in VBA

Please Login or Register  to view this content.

[scottiex]

Try

Please Login or Register  to view this content.

For me this swaps dd and mm to us format but probably that's just my settings - otherwise easy enough to fix...

Oh well looks like Crooza beat me

[ScotyB]

Thanks, Crooza and scottiex,

tried those variations at work last night and all is good.

Cheers,

AJ

[Crooza]

Great and thanks for the rep points