Compare Date

[rafidwh]

Hi All,

I need to compare the input date which is in yyyymmdd format with the date which is passed as a parameter also in yyyymmdd.

my condition is if in.date > par.date then 0 else in.date

Please give the options to get the result
Regards,
Rafidwh

[ray.wurlod]

Is the input date a date or a string? If it's a string, and the parameter is a string, you can compare them directly. If one is a date and the other is a string, then you need to convert one or the other so that the data types are compatible for comparison.

[rafidwh]

The input is in dd/mm/yyyy , if it valid then iam converting it into yyyymmdd using DatetoString(StringtoDate) function and then it is compared with yyyymmdd (parameter value)