DateSerial formula error (invalid syntax) on a form

[Brianwarnock]

Sorry, I did not reply to your message. Your original sollution on post 6 did not work and as I understand it's a problem of regional settings not access.

For some reason nobody suggested that it could be regional settings so I was stumped at it for 2 days. Sorry if my actions were rude or anything I did not mean it.

Try rereading post #6 where I suggested it, without spelling it out perhaps.

Brian

 

[smile]

Try rereading post #6 where I suggested it, without spelling it out perhaps.

Brian

Does not work, because your separator is "," and I need it to be ";" I changed to =Format(DateSerial(Year(Now());Month(Now());1);"YYYY.M.D")

and it seems to work but as I said it's a problem of regional settings not access besides nobody suggested that it could be regional settings as I posted that my decimal separator is "," on post 4.

Case closed works fine now. How about my other question about the buttons?