Regadring Date Conversion and Comparison

ksv2584 · Post by **ksv2584** » Thu Mar 31, 2011 10:38 pm

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

chulett · Post by **chulett** » Thu Mar 31, 2011 10:42 pm

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

jwiles · Post by **jwiles** » Thu Mar 31, 2011 11:47 pm

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,