min of two date

consulting · Post by **consulting** » Sat Oct 25, 2008 9:46 am

My reqriment is to find the minimum of two dates like (date1,date2)
How to do without transformation?

eg 05/11/2008 05/12/2008

i want output as 05/112008

chulett · Post by **chulett** » Sat Oct 25, 2008 9:50 am

You can't. You need to "transform" them into something you can compare - either an ISO YYYY-MM-DD external format or an internal date using StringToDate().

kittu.raja · Post by **kittu.raja** » Tue Oct 28, 2008 11:02 am

[quote="consulting"]My reqriment is to find the minimum of two dates like (date1,date2)
How to do without transformation?

Hi,

You can do it in a tranformer. First convert the date to julian date which is a function in trnasformer and using aggregate function find the min. value and again convert back to original date.

DSXchange

min of two date

min of two date

Re: min of two date