Error on insert into command

[Welshgasman]

# delimiter was there.

" , #" & Format(dt, "yyyy-mm-dd") & "# , "

But in case of using the constant do I just change it's declaration as below?

Const dt = Me.Paid_Dt

any other change?

No, the constant is to be used as the format string?



You are not grasping how this is meant to work?

All it is, is a format string in the format required, but rather than having to remember the syntax each time, you just need to remember a name, and if you cannot do that, then all you need to do is review a certain module, where it is stored?

When you post code, post ALL the relevant code, not just a snippet which makes the code look incorrect.

[bubai]

All it is, is a format string in the format required, but rather than having to remember the syntax each time, you just need to remember a name, and if you cannot do that, then all you need to do is review a certain module, where it is stored?

Can you modify my code?

[Welshgasman]

No need. You just add my constant and refer to it as I have done.
If you are happy with the way you have done it and it works, stick with that. yyyy-mm-dd is unambiguous.