kdog119
03-16-2014, 04:17 PM
Hi,
I cannot figure out why my VBA is returning a result different to what I'm expecting.
I have the following line of code:
numDays = DateDiff("d", Now, LastTestDate)
In debug mode the result is '-111'.
However, when I try to get the length of 'numDays':
strLen = Len(numDays)
It returns the value of '2'.
Can anyone help explain this please?
Cheers,
K.
I cannot figure out why my VBA is returning a result different to what I'm expecting.
I have the following line of code:
numDays = DateDiff("d", Now, LastTestDate)
In debug mode the result is '-111'.
However, when I try to get the length of 'numDays':
strLen = Len(numDays)
It returns the value of '2'.
Can anyone help explain this please?
Cheers,
K.