Cannot write a proper format function in MS Access query

Question

When I try to write Format([my_date_element], "yyyy/mm/dd") I get an error because of bad syntax.

What is the exact error message? What date type is my_date_element? What is the full SQL statement? — Andy G
– Andy G, Commented Feb 21, 2018 at 15:32
Ok, I solved a problem, but thank you Andy, because when I changed the SQL statement everything worked just fine. Then I noticed that in a project view the above expression changed to Format([my_date_element], "rrrr/mm/dd"). It's because in my language (Polish) "year" means "rok" and it appears that I have to use Polish symbols in project view next time when I have MS Access set to Polish. — Piotr
– Piotr, Commented Feb 21, 2018 at 15:50

Piotr · Accepted Answer · 2018-02-21 15:58:26Z

2

In the project view of a query you have different symbols depending on the language you use. So e. g. "year" means "rok" in Polish and thus I have to use "r" instead of "y" in Format function.

answered Feb 21, 2018 at 15:58

Piotr

211 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

wazz Over a year ago

Add a note about where the language is set; is this an Access setting or an OS setting?

Collectives™ on Stack Overflow

Cannot write a proper format function in MS Access query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related