iif expected end of statement

  • Thread starter Thread starter Cristen
  • Start date Start date
C

Cristen

Hello. I'm trying to use this code that omits weekend days from a date
calculation. I get an Expected: end of statement error. I am not sure what
to do. I took this code off of another post I found on this site. so I am
not too advanced at this. Thanks!

..iMin = DateDiff("d", sPrevDate, sAppDate) - _
DateDiff("ww", sPrevDate, sAppDate, vbSunday) * 2 _
IIf(Weekday(sAppdate, vbSunday)= vbSaturday, _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, 0, 1), _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, -1, 0))
 
Cristen said:
Hello. I'm trying to use this code that omits weekend days from a date
calculation. I get an Expected: end of statement error. I am not sure
what
to do. I took this code off of another post I found on this site. so I am
not too advanced at this. Thanks!

.iMin = DateDiff("d", sPrevDate, sAppDate) - _
DateDiff("ww", sPrevDate, sAppDate, vbSunday) * 2 _
IIf(Weekday(sAppdate, vbSunday)= vbSaturday, _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, 0, 1), _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, -1, 0))
Click to expand...


It seems to me that there should be an operator of some kind after the 2 in
this line:
 
Back
Top