Formatting Date within Do.Cmd.RunSQL

Hi All

I have a routine which keep putting in a date in the U.S. format and I am in the UK. I have tried to research and come up with a solution but still can't get it to work. Does anyone have any clues please?

Code:

---

Application.DoCmd.RunSQL "INSERT INTO temp_tbl_QBData([flicksfeedbackleft], [class], [qNAME], [EventID], [vatamount], [totalvat], [totalinv], [acct], [incomeAccount], [filmNameDescription], [today], ) VALUES

...lots of other fields here....


"#" & Format(.Fields("today").Value, "dd-mm-yyyy") & "#,"

---

Thanks for any help.

Formatting Date within Do.Cmd.RunSQL