In Expression Calculator:
- when 'dtDateToJulian (Date)' is used, datatype returned is 'Long'.
- When it is used in cascaded with dtDateFromString, datatype returned is 'datetime'.
This can be caused due to defect present in Sagent releases before v6.8.9.
ResolutionUPDATED: September 17, 2019
This has been fixed in v6.8.9, therefore, upgrading to it or later releases should resolve this problem.