By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,883 Members | 2,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,883 IT Pros & Developers. It's quick & easy.

conditionals

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

P: n/a
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?
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.