Comparison of two dates in two different rows using Column Expressions

[prashant7526]

I need Help
I have to perform the below operation in a Multi-Row enabled Column Expressions:

if(isMissing(column("Event End Date")))
{
   if(!isMissing(column("Event Start Date", -1))){
        if(date(column("Event Start Date")) < date(column("Event Start Date", -1))){
            "2024-05-24"
        }else{
            "2024-05-27"
        }
   }else{
        column("Event End Date")
   }
}
else{
    column("Event End Date")
}

The below part is not working:

 if(date(column("Event Start Date")) < date(column("Event Start Date", -1))){
            "2024-05-24"
        }else{
            "2024-05-27"
        }

In the above snippet, if I change > to <, it always shows me “2024-05-27”. In my case (“<”), it should show me “2024-05-24”.
Note: Both fields are Date type.

[prashant7526]

I am Sorry, it worked.

I had to use: column(“Event Start Date”, 1) instead of column(“Event Start Date”, -1)

[ScottF]

Thanks for posting your solution!