On 13 nov, 15:02, "
wrote:
On 13 nov, 14:44, "

wrote:
Sorry, this is not working

Regards Giel

I have changed MyDate into a Double
This gives the proper value when stepping through the code.
But it does not give the value to MyDate in the Query.

Is there a way to solve this?

Giel

After a little search I found the trick:

'" & MyDate & "'

Now it works fine