Is there a way to hard code date automation?

Hi there community!
I’m trying to use Monday.com for sprint planning.
Each sprint is a group in the board.
I’m looking to simply update the due date or timeline of a task when I move it from sprint to sprint. So when I move a task to the backlog then the time or due date will automatically change to that of the group.

It doesn’t seem to be an option in the automation, or am I missing something? There’s an option to set the date as today, or to push a date by x days, but not set a specific date.

Any suggestions? Anyone else using this for sprint planning?

Many thanks,

Ricky