How to find max date

[somu_june]

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.

[relati]

What is the date format in the Input fields?

[ray.wurlod]

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

[somu_june]

Hi,


It is Varchar(10)




Thanks,
Somaraju

[somu_june]

Hi,


It is Varchar(10) and it has YYYYMMDD format




Thanks,
Somaraju

[relati]

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

[somu_june]

Thanks folks

[ray.wurlod]

Please mark thread as Resolved.