I have a simple Excel spreadsheet with a column with a date (MM/dd/yyyy format) that I am trying to import using PDI. I
used the Excel import function and I configured the step to import the date field as a string because sometimes the
Excel date column contains a invalid date string.
I tried to use the Modified Java Script Value step to create a output that would be a valid date or an empty date when the
date string is invalid. My attempts have failed and not produced a date output.
Can someone assist me by offering a script that I can use to convert a string to a date (MM/dd/yyyy) when the string is a
valid date and output no date when the input string is not a valid date. This is driving me nuts.