Help with Date Ranges

  • Thread starter Thread starter jen-chi
  • Start date Start date
J

jen-chi

I'm trying to show "within TRTW" or "Not TRTW" using fields already in my
query. This is what I have been trying but I get the following error "You
must enclose IIF function arguements in Parentheses"

Status Within TRTW?: (IIF[Time Tracking]![Benefit Begin Date] Between [TRTW
- Scorecard]![Date entered TRTW?], And [TRTW - Scorecard]![Date Released from
TRTW?], "Within TRTW", "Not TRTW")

Please help.....
 
Hi jen-chi,

I think you have a couple extraneous characters in that. Remove the
leading ( and the first , and it should be okay.

Clifford Bass
 
I'm trying to show "within TRTW" or "Not TRTW" using fields already in my
query. This is what I have been trying but I get the following error "You
must enclose IIF function arguements in Parentheses"

Status Within TRTW?: (IIF[Time Tracking]![Benefit Begin Date] Between [TRTW
- Scorecard]![Date entered TRTW?], And [TRTW - Scorecard]![Date Released from
TRTW?], "Within TRTW", "Not TRTW")

Please help.....
Click to expand...

That is correct. You must enclose the function arguments within
parenthesis.
The correct syntax for a function is
FunctionName(arguments)

Look at your code again.
You placed the opening parenthesis outside the IIf
(IIf [Time ..... etc.

It should be inside, surrounding the arguments:

Status Within TRTW?:IIF([Time Tracking]! .... etc....
 
Hi Fred,

Good catch. I missed that he had it reversed. However, he still needs
to remove the first comma.

Clifford Bass

fredg said:
I'm trying to show "within TRTW" or "Not TRTW" using fields already in my
query. This is what I have been trying but I get the following error "You
must enclose IIF function arguements in Parentheses"

Status Within TRTW?: (IIF[Time Tracking]![Benefit Begin Date] Between [TRTW
- Scorecard]![Date entered TRTW?], And [TRTW - Scorecard]![Date Released from
TRTW?], "Within TRTW", "Not TRTW")

Please help.....
Click to expand...

That is correct. You must enclose the function arguments within
parenthesis.
The correct syntax for a function is
FunctionName(arguments)

Look at your code again.
You placed the opening parenthesis outside the IIf
(IIf [Time ..... etc.

It should be inside, surrounding the arguments:

Status Within TRTW?:IIF([Time Tracking]! .... etc....
Click to expand...
 
Back
Top