[Tesco]

Hello.
How do I get the first to characters of a var? I was told I needed to use Left() or something? Could some please explain how to use this sub properly?
TIA

[Shane]

Try:

Code:

Dim strThing, strTwo
strThing = "hello"

strTwo = Left(strThing, 2)

Usage for the Left function:

Left(STRING_HERE, LENGTH_HERE)

[Tesco]

Thanks, that worked.

But, I need a little more help.

I'm doing this to get the first two characters of two dates (i.e. they're day), which I can do successfully now.

But, later in my code, I try to subtract one from the other, but I get 'type mismatch' error on the line that performs this arithimatic.

Could you help?
Ta.

[Shane]

Are you trying to find the difference between two dates? If so, then there is an easier way to do so. (http://msdn.microsoft.com/library/de...ctdatediff.asp)

But anyway, try converting your variables to integers using:

Code:

intTwo = cint(strTwo)

[Tesco]

Tried that, still get type mismatch error.

Yeah, I am comparing to dates, but I thought that DateDiff() only worked on SQL Server? I don't have access to that

[Shane]

Originally posted by Tesco
Tried that, still get type mismatch error.

Yeah, I am comparing to dates, but I thought that DateDiff() only worked on SQL Server? I don't have access to that

Nah, you don't need SQL Server. You just have to make sure your two dates are in the form of the Date data type.

This should work....

Code:

firstDate = CDate(strDate)
secondDate = CDate(strDateTwo)

theDifference = DateDiff("d",firstDate, secondDate)

Also, if you want me to help fix your existing code, please post it so I can see what you are doing.

BTW: this is a great reference.. http://msdn.microsoft.com/library/de...ctdatediff.asp

[Tesco]

Thanks Shane, got it working with DateDiff()

[Shane]

Not a problem.