Asterisk characters in Dataset date field

jerome_rajan · Post by **jerome_rajan** » Mon Feb 15, 2016 5:55 am

Hi All,

I am trying to view the data in a date field in a dataset but all I get are these * characters. Not sure why. The datatype of the field is DATE in DataStage but when I try to load the Oracle table, it throws an error. I'm trying to catch the culprit but the Dataset isn't showing me the actual data

Mike · Post by **Mike** » Mon Feb 15, 2016 8:35 am

You've written something that is not a valid date into a date field in your dataset.

You need to look upstream from the dataset to determine where the invalid date originates.

Mike

vamsi_4a6 · Post by **vamsi_4a6** » Mon Feb 15, 2016 9:14 am

you can use Isvalid function to identify the invalid dates

chulett · Post by **chulett** » Mon Feb 15, 2016 9:17 am

They may not be invalid as much so improperly converted. Nature vs. nurture.

Hard to say without knowing the source and how the data is being manipulated before we got here.