whats wrong

[MAMIBUSSOL]

whats wrong with this statement


COMPAREVALUE1 = startmonth + " " + Year(startdate)

 

[shg]

Try replacing the + with & -- assuming startmonth is a string.

+ will work as the catenation operator, but only with strings, and Year returns a number.

Or COMPAREVALUE = Format(startdate, "mmm yyyy")

 

[MAMIBUSSOL]

Thanks

using this statement

COMPAREVALUE1 = startmonth & " " & Year(startdate)

gives me a value of MAY 2010, I need to adjust this statement to give me a end result of MAY 10

 

[shg]

How about ...

COMPAREVALUE = Format(startdate, "mmm yy")