'Datatype mismatch error' message in Sagent


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


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


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