DSXchange

I have requirement where i need to compare two dates say ReportDate and StartDate.

I'm comparing thie two dates in a filter stage as "ReportDate > StartDate".
StartDate is present in the input dataset of format yyyy-mm-dd and ReportDate is a parameter for which the value i'm giving as '2008-02-01'.

But my job is aborting throwing error at "-".

Do i need to convert into some format for comparison..

Please provide inputs to this...

You cannot compare two dates in a filter. Use a transformer and the fonction DaySinceFromDate(date1,date2)

You can compare 2 dates in a filter stage only if the second date is explicitly specify. ex : DaySinceFromDate(date1,'2009-02-27')

Martin