Help with Flag field

S

Steve

I'm trying to put a formula in a flag field to set yes if a start date is
between certain dates. But I can't seem to make the formula work properly.
IIF([Start]>"10/01/04" OR [Start] < "9/30/05",Yes,No.

I've tried different variations but get wrong answers. Would appreciate
suggestions.

Steve
 
G

Gérard Ducouret

Hello Steve,

Try this :

IIf([Start]>"10/01/04" And [Start]<"9/30/05",Yes,No)

Gérard Ducouret
 
S

Steve

It doesn't work for me, I get all "Yes"s. I know this should be simple.

As a test, I made 5 enteries of 20 days each. First starting on 4/1/03 and
one in years 04, 05, 06, 07. The suggested formula in flag1.

I should have gotten one "Yes" and four "No"s, but its not working that way!

Gérard Ducouret said:
Hello Steve,

Try this :

IIf([Start]>"10/01/04" And [Start]<"9/30/05",Yes,No)

Gérard Ducouret

Steve said:
I'm trying to put a formula in a flag field to set yes if a start date is
between certain dates. But I can't seem to make the formula work properly.
IIF([Start]>"10/01/04" OR [Start] < "9/30/05",Yes,No.

I've tried different variations but get wrong answers. Would appreciate
suggestions.

Steve
Click to expand...
Click to expand...
 
G

Gérard Ducouret

Steve,

May be a date format issue.
Could you send me (email) the mmp file ?
Remove the NOSPAM in my email.

Gérard Ducouret

Steve said:
It doesn't work for me, I get all "Yes"s. I know this should be simple.

As a test, I made 5 enteries of 20 days each. First starting on 4/1/03 and
one in years 04, 05, 06, 07. The suggested formula in flag1.

I should have gotten one "Yes" and four "No"s, but its not working that way!

Gérard Ducouret said:
Hello Steve,

Try this :

IIf([Start]>"10/01/04" And [Start]<"9/30/05",Yes,No)

Gérard Ducouret

Steve said:
I'm trying to put a formula in a flag field to set yes if a start date is
between certain dates. But I can't seem to make the formula work properly.
IIF([Start]>"10/01/04" OR [Start] < "9/30/05",Yes,No.

I've tried different variations but get wrong answers. Would appreciate
suggestions.

Steve
Click to expand...
Click to expand...
Click to expand...
 
Top