'Datatype mismatch error' message in Sagent

Issue

In Expression Calculator:
  • when 'dtDateToJulian (Date)' is used, datatype returned is 'Long'. 
  • When it is used in cascaded with dtDateFromString, datatype returned is 'datetime'.
Plan execution fails with 'Datatype mismatch error' message

Cause

This can be caused due to defect present in Sagent releases before v6.8.9.

Resolution

UPDATED: September 17, 2019
This has been fixed in v6.8.9, therefore, upgrading to it or later releases should resolve this problem.