DSXchange

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

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

you can use Isvalid function to identify the invalid dates

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.