Date comparsion in transformer

[bicap]

Hi All,
I need help in compare two date fields in datastage parallel job transformer stage

Both the start date and end date fileds are NULLABLE NO yes fields.

Example
================
start date :2015-12-20
End date :2015-09-19

I just want to know whether start is greater than End date in datastage transformer

[chulett]

So... what happens when you actually compare them? Actual dates or strings in that format should compare just fine without any kind of secret sauce added.

[ray.wurlod]

What kind of comparison is required? Are they actual Date fields, or are they string data type?

[karteek]

if start_date and end_date datatypes are DATE then in transformer convert both date fileds to days then you can comapre both of them

take 3 stage variables
1.SvStartDate: JulianDayFromDate(lk.start_date)
2.SvEndDate: JulianDayFromDate(lk.end_date)
3. CALC: if SvStartDate > SvEndDate then 'X' Else 'Y'

[ArndW]

If "start_date" and "end_date" are both DATE datatypes then no conversion is necessary in order to compare them.