Date problem with CreateQueryDef

[Doppenberg]

Can someone please help me? I am using a dutch date format (dd-mm-jjjj).
When a user types a date into a form and pushes the report button. A report is created based on a newly created Query.

In the CreateQueryDef I use the name of the controlfield, surrounded by #. This works ok.

The problem is that in the new query the criteria is the date from the controlfield with the days and months swapped (mm-dd-jjjj)
How can I keep my dutch date format ?
The controlfield's format is set on short date notation in dutch, so that should be ok.

Any help will be greatly appreciated.

Tim.

 

[Doppenberg]

Thanks Pat,

I found out that a funcion called "Datevalue" takes care of the problem.
When you use this function instead of
#date# , the date is automatically converted to the US format.

Gr. Tim.