Date validation to specific year for list Column in view

Question

I've got a date column in a view and I'm using a validation formula:

=IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE)

So that users can only insert date within the year 2018.

• I always get an error when saving the formula, how come?
• One more question, not quite related, should we mainly do validation through Powerapps forms? Is this the best practice that MS is suggesting for sharepoint?

I'm using sharepoint 365

I've also tried inserting the formula as Michael Han_MSFT suggested:

=TEXT([Data documento],"yyyy")="2018"

But unfortunately I still get an error message as shown below

Answer 1

You need change the validation formula to this:

=TEXT([Data documento],"yyyy")="2018"

Try to use this in list validation. Go to list settings-> validation settings:

Answer 2

Please try using below formula:

=TEXT([columnname],"yyyy")="2018"

I tried using TEXT(created,"yyyy")="2018"

Please do it on list validation. by going through List Setting-->Validation Setting.