Vbscript - Type mismatch

Question

Hi guys 
 
 I got a problem with the following script after copying a vault (full backup) to another server. 
 Dim EndeGJ_ID: EndeGJ_ID = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("PD.EndeGJ")
	Dim EndeGJ: EndeGJ = PropertyValues.SearchForProperty(EndeGJ_ID).TypedValue.DisplayValue
	Dim neuesJahr: neuesJahr = YEAR(DateAdd("yyyy", 1, EndeGJ)) 'Das Jahr von (EndeGJ + 1 Jahr) 
 In my environment it works, but not in the new one. It always says when triggering the workflow state with the script: type mismatch. 
 There is a property "Ende GJ" (date) where it should be added 1 year when running the script. 
 
 Someone knows why the exact same script doesn't work in the new vault? 
 
 Kind regards, 
 Dario

bright-ideas.dk · Answer

Hi Dario, 
 The detailed error message has information on which line of the script causes the error. This is quite helpful when debugging. Type mismatch often goes back to the variable used in that line. You may have to backtrack and perhaps temporarily insert a line with "Err.Raise MFScriptCancel, <your variable>" to check the content of that variable and compare it to the required input in the line that causes the error. 
 In line 11 of the function you use EndeGJ as input. Is EndeGJ a valid date in a format that is recognized by the DateAdd function? 
 BR, Karl

Vbscript - Type mismatch

Top Replies