DSXchange

Hi,

Iam getting three date fields X,Y and Z and there data types is varchar(10) . I want to find the maximum date from X,Y and Z and send to the output. Do I need to convert string to Date and then find Maximum of XYZ or can I do it with out converting . The final output data type to which I should map maximum date is Varchar (10)


Thanks,
Somaraju.

What is the date format in the Input fields?

You can do it without conversion if the date strings are in a sortable format, such as YYYY-MM-DD.

Hi,


It is Varchar(10)




Thanks,
Somaraju

OK, then you can compare them without converting and pick the max.

Thanks folks