Problems with expressions buider

[alberigo67]

Hi to everyone,


can anyone told me where is the error in this code in the expression builder?

=Right(Year([Date]);2)

the result of the function goes insede a textbox but what it returns is:

#Nome?

Thanks for your help.

[Bob Fitz]

Try:

=Right(Year(Date());2)

[moke123]

Hi to everyone,
can anyone told me where is the error in this code in the expression builder?

=Right(Year([Date]);2)

the result of the function goes insede a textbox but what it returns is:

#Nome?

Thanks for your help.

If [Date] is a field you should change the name as date is a reserved word.
Are you sure you want a semi-colon instead of a comma before the 2?
(Not sure where your from and I believe some non-english versions of access use ; instead of ,)

[alberigo67]

Try:

=Right(Year(Date());2)

thank you....your solution is the right one.