VERIFIED SOLUTION i
X

Sagent: Incorrect "Output Column" length in Expression calculator when function dtDateFromString is cascaded with dtDateToString.

Issue

In Expression calculator, length of Output column in function "dtDateToString (Date)" should be automatically set to the length of Input String.

But when dtDateToString function is used in cascading with dtDateFromString function, Output Column length is set incorrectly.

For Example, in the expression: "dtDateToString ( dtDateFromString (STRDATE ,'YYYYMMDD' ) ,'YYYYMMDD')",  the length of Output Column length is set to 2 instead of 8 (Considering STRDATE input column is of length 8).
 
User-added image

Cause

This is a defect with workaround available.

Resolution

UPDATED: March 24, 2017


Following workarounds are available:

1. In the Expression Calculator, set proper length in "Fixed at" option, under "Result Length" tab and the length is updated correctly. But automatic update does not work in this case.
 
User-added image


2. Instead of cascading the expression, create a separate expression (Calculated1) using dtDateFromString and use it in dtDateToString function (Calculated2).
 
User-added image

Environment Details

Product Feature: Expression Calculator
 

Downloads

  • No Downloads