Type Mismatch

Results 1 to 4 of 4

Thread: Type Mismatch

  1. #1
    Join Date
    Dec 1969

    Default Type Mismatch

    I&#039;m trying to do a for loop where I step along a date at a time using a datevalue in a variable called expecteddate, see below<BR><BR>for ii = 0 to aa-1<BR> if datevalue(bookedarray(ii)) &#060;&#062; datevalue(dateexpected) then <BR> nextfreedate=bookedarray(ii) <BR> end if<BR> dateexpected=dateexpected+1<BR>next<BR><BR>It doesn;t like me incrementing the dateexpected value by 1. it comes up with a type mismatch error. How do I resolve this? <BR><BR>I know you lot will not fail me.

  2. #2
    Mike Shaffer Guest

    Default RE: Type Mismatch

    RTFineM<BR><BR>Look at the DateAdd() function.<BR>

  3. #3
    Steve Cimino Guest

    Default RE: Type Mismatch

    This makes no sense...<BR><BR>are you trying to increment the value inside the array, or just it&#039;s counter? WHAT is in dateexpected.. is it an integer? It needs to be.

  4. #4
    Join Date
    Dec 1969

    Default sorry - not enough info

    what is dateexpected initialised to?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts