Filter With Many Effective & Expiration Dates

A

alex

Hi,

Can anyone tell me how do I do a filter under the query criteria with many
effective & expiration dates but only want to see the values for effective
dates from X period of time.

Period: EFFECTIVE AFTER 12/01/09

Example:

Effective Expiration

1/1/09 Blank WANT TO SEE
1/1/09 2/28/10 WANT TO SEE
3/1/10 BlankDO NOT WANT TO SEE
1/1/09 1/31/10WANT TO SEE
 
C

Ca Da

Hi,

Can anyone tell me how do I do a filter under the query criteria with many
effective & expiration dates but only want to see the values for effective
dates from X period of time.

Period: EFFECTIVE AFTER 12/01/09

Example:

Effective               Expiration

1/1/09          Blank         WANT TO SEE
1/1/09          2/28/10 WANT TO SEE
3/1/10          BlankDO NOT WANT TO SEE
1/1/09          1/31/10WANT TO SEE
Click to expand...

I don't think you have gotten a reply because your question is not
clear.

why not just the criteria >1/1/09 in either the effective or
expiration column?? (or whatever date you want...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Smart Filter For My Query 1
Calculating interest due on late loan payments 1
XIRR vs. IRR Function 11
Select 1st date of subsequent month based 4
Dates - gaps between 3
Special Filter In My Query 2
Criteria in a calculated query field 6
dsum - 1

Top