Skip to Content
0
Former Member
Jun 25, 2010 at 07:10 AM

UDF Help - CompareDate UDF Function with True/False output.

62 Views

Hi Gurus,

I have a scenario in MessageMapping where I want to compare 2 dates against 3rd date. Basically I am looking to input all three dates and compare two against the last one as shown below.

StartDate

InputDate

EndDate

I want to check,

StartDate = (or) < Inputdate

and

EndDate = (or) > Inputdate

I have used Standard CompareDates function with Fixvalue function to comeup with the solution. Since my Mapping is very complicated, I want to simplify this using UDF.

Appreciate any response. Thanks.

Regards,