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'.
Cause
This can be caused due to defect present in Sagent releases before v6.8.9.
Resolution
UPDATED: September 17, 2019This has been fixed in v6.8.9, therefore, upgrading to it or later releases should resolve this problem.