Alert Composer - Need to get Future Assignment Effective start date

Hi,

HR is doing Transfer Transaction to Employee from 01-Oct-24. We want to send a Alert notification to employee when HR completes the Transaction i.e 2-Sep-2024.

We created a custom Alert and used the Groovy script " ${emps.assignments.EffectiveStartDate} "to get the Assignment date of Transfer. Here we are getting current Assignment Start date but not 01-Oct-24.

May i know how can we get Future Assignment Start date instead of Current Assignment start Date.

Thanks,

MJANA