Why am I getting error Type mismatch in operator +

Question

'= IF(A'+ ToString(([Record Added Date])+1,0) +'>$B$6,'+'"New",'+'"Existing"'

Date Type [Record Added Date]: Date Time

The below formula works to have an excel output with formulas. Where [Record ID (Column A)] is Byte Data Type

"= (B"+tostring([Record ID (Column A)]+1,0)+"*C"+tostring([Record ID (Column A)]+1,0)+")"

Christina_H · Answer

You're trying to add 1 to a datetime field, which isn't possible.  If you want to add something to the date you need to use the DateTimeAdd function.

e.g. '= IF(A'+ ToString(DateTimeAdd([Field1],1,'day'),0) +'>$B$6,'+'"New",'+'"Existing"'

Although the output doesn't make sense for an Excel formula.  Is this actually the output you want?

mceleavey · Answer

Hi @ndubal ,

because the data types are different.

In the formula you are using a Tostring() to change the preceeding number to a string which you are then attempting to add to a number. Try wrapping the tostring in a tonumber():

'= IF(A'+ tonumber(ToString(([Record Added Date])+1,0)) +'>$B$6,'+'"New",'+'"Existing"'

I hope this helps.

M.