conditionals

[steven]

Is it possible to combine conditionals to call out data?
I have a list of records that include a date. I can call out all dates
after the date after tomorrow:
IIf(Date()+1)<[date],...,...
And I can call dates before next week:
IIf([date]< Date()+7,...,...

But I'd like to isolate those that fall between the day after tomorrow
and next week. I was thinking that this would work, but it doesn't:

IIf((Date()+1)<[date]<(Date()+7),...,...

Any hints?

[Salad]

steven wrote:

Is it possible to combine conditionals to call out data?
I have a list of records that include a date. I can call out all dates
after the date after tomorrow:
IIf(Date()+1)<[date],...,...
And I can call dates before next week:
IIf([date]< Date()+7,...,...

But I'd like to isolate those that fall between the day after tomorrow
and next week. I was thinking that this would work, but it doesn't:

IIf((Date()+1)<[date]<(Date()+7),...,...

Any hints?

First, the word is cull, not call.

If you are talking about this in a query
Select * From Table
Where DateField Between Date() + 1 And Date() + 7

You could have done
DateField > Date() + 1 And DateField < Date() + 7

[MacDermott]

"Salad" <oi*@vinegar.com> wrote in message
news:XT*****************@newsread1.news.pas.earthl ink.net...

First, the word is cull, not call.

I checked in Dictionary.Com, and found that "cull" has 2 meanings,
1. To select or gather
2. To remove rejected members or parts

It looks to me as if the OP wants to select specific data, rather than
remove it.
So in this case, using "cull" would be pretty ambiguous.

I think the most commonly used technical term here would be "select".
Beyond that, I don't see that "cull" is any more desirable than "call".

Just my opinion
- Turtle

[steven]

Salad <oi*@vinegar.com> wrote in message news:<XT*****************@newsread1.news.pas.earth link.net>...

steven wrote:

Is it possible to combine conditionals to call out data?
I have a list of records that include a date. I can call out all dates
after the date after tomorrow:
IIf(Date()+1)<[date],...,...
And I can call dates before next week:
IIf([date]< Date()+7,...,...

But I'd like to isolate those that fall between the day after tomorrow
and next week. I was thinking that this would work, but it doesn't:

IIf((Date()+1)<[date]<(Date()+7),...,...

Any hints?

First, the word is cull, not call.

If you are talking about this in a query
Select * From Table
Where DateField Between Date() + 1 And Date() + 7

You could have done
DateField > Date() + 1 And DateField < Date() + 7

Actually, I was trying to use this in a report. I want the expression
to produce the day of the week starting from the day after tomorrow
within the next week. Right now, the expression I'm using is very
cumbersome:
IIf([Date]= Date(),"Today","") &
IIf([Date]=(Date()+1),"Tomorrow","") &
IIf([Date]=(Date()+2),Format([Date],"ddd")," ")&
IIf([Date]=(Date()+3),Format([Date],"ddd")," ") &
etc., etc.

I was hoping to collapse the last few lines into
IIf((Date()+2>[Date]>(Date()+7),Format([Date],"ddd")," ")

I don't know whether something like this is possible. Maybe there's
something that can be added to the expression to enable this?