DSXchange

Hi

I have input column having date value with char Datatype with value in the format (yymmdd)
ex:110110

Now i need to compare with the job run date(which Iam passing as parameter in fomat yymmdd) whether the input date is greater than or equal to this date

so when converting the input value using String to date,how i nedd to pass the parameters

Please help

Thanks in advance

Why convert anything? That format will allow you to compare the char values directly.

If you still feel you have to convert the dates, you can use the modify stage function date_from_string or the transformer function StringToDate, using the proper date format specifiers. All of these are documented in the Parallel Job Developer Guide included with Information Server.

Regards,