M
Marcie
I am trying to calculate the number of days between a hard date (7/1/2008)
and a calculated field (newstepdate) only if a field (step < 7) and
(newstepdate < 7/1/2009). the below code works except when month is 10 11
or 12. I am guessing this may be some type of converting problem but I
cannot come up with any conversion that seems to resolve it.
IIf(([PayrollDetail]![Step]<7 And
[newstepdate]<"7/1/2009"),(DateDiff("d","7/1/2008",[newstepdate])))
and a calculated field (newstepdate) only if a field (step < 7) and
(newstepdate < 7/1/2009). the below code works except when month is 10 11
or 12. I am guessing this may be some type of converting problem but I
cannot come up with any conversion that seems to resolve it.
IIf(([PayrollDetail]![Step]<7 And
[newstepdate]<"7/1/2009"),(DateDiff("d","7/1/2008",[newstepdate])))