It is in a parameter query, where arrival_date = ?m.arrival_date. If I call it from a form with

m.arrival_date = thisform.arrival_date1.value,
requery("arrivals_view")

it works fine
I am writting a report based on the same view, and when I try to test it, I get a dialog asking for the parameter. If I try DATE() I get the error message. If I try the format they give as an error message {^1999-12-24} I still get the message. I have tried {^1999/12/24} also with similar results I have tried evrything I can think of with no better results. This is making testing the report (which will be called from the same form above, to print out arrival information for the current person's booking)