Execute SQL Statement - Date Issue

HI

i have the following execute sql statement action running on a opportunity workflow rule:

Insert into fundlink (flnk_fundid, flnk_personid, flnk_opportunityid, flnk_invamt, flnk_invdate)

values (#oppo_fundid#, #oppo_primarypersonid#, #oppo_opportunityid#, REPLACE('#oppo_forecast#' , ',', ''), '#oppo_closed#');

all works ok apart from the date that its setting - e.g the closed date on the opp is 09/11/2021 but when this rule is running its setting the flnk_invdate field to 11/09/2021

any idea?