Solved Syntax error when filtering year and date (1 Viewer)

[cheberdy]

I always get a syntax error when I try to pull the year and month from a date.
My code in the query is

Year: Format([date]; "yyyy");

and

Day: Format([date]; "dd");

if I do the same with month it works. Am I doing something wrong?

 

[ebs17]

Remove the semicolon behind the closing parenthesis.

 

[Gasman]

Why not just use the functions by the same name?, or is there a reason you want a string?

 

[cheberdy]

Remove the semicolon behind the closing parenthesis.

Yes I get no syntax error but now I am only shown 4 y and 2d

 

[Josef P.]

What does the expression look like in the SQL view?

 

[Gasman]

Yes I get no syntax error but now I am only shown 4 y and 2d

What does that even mean?,
4 character year and 2 character day ?

 

[cheberdy]

What does the expression look like in the SQL view?

Format([date],"""yyyy""") AS year
Format([date],"""dd""") As day
I don't know why there are three quotation marks now. It keeps jumping back to this.

 

[cheberdy]

What does that even mean?,
4 character year and 2 character day ?

it means
year / day
yyyy _____dd

 

[Josef P.]

Format([date],"""yyyy""") AS year
Format([date],"""dd""") As day
I don't know why there are three quotation marks now. It keeps jumping back to this.

Ok, your office language is not English.

SQL:

Format([date], "yyyy") as year

In German Office language, the expression in the query editor should look like this:

Year: Format([date]; "jjjj")

Note: This automatic translation bothers me, so I always set the language to English on the development PC.

 

[cheberdy]

Ok, your office language is not English.

SQL:

Format([date], "yyyy") as year

In German Office language, the expression in the query editor should look like this:

Year: Format([date]; "jjjj")

Thanks