Skip to main content
added 282 characters in body
Source Link
Popkornak
  • 163
  • 3
  • 14

If the field is not required to be editable in the future, you can simply create a new calculated column, set as date with this formula:

    =DATE(YEAR([Created]2023)+1,MONTH([Created]),DAY([Created]))

Where instead of [Created] you can add your column name.

You can also use YEAR(TODAY()), but please keep in mind that calculated fields are "recalculated" on item create/edit with TODAY() so you might experience some issue so rather hardcode the correct value like YEAR(2O23) or YEAR([Created]+1) might be more suitable.

If the field is not required to be editable in the future, you can simply create a new calculated column, set as date with this formula:

=DATE(YEAR([Created])+1,MONTH([Created]),DAY([Created]))

Where instead of [Created] you can add your column name.

If the field is not required to be editable in the future, you can simply create a new calculated column, set as date with this formula:

    =DATE(YEAR(2023),MONTH([Created]),DAY([Created]))

Where instead of [Created] you can add your column name.

You can also use YEAR(TODAY()), but please keep in mind that calculated fields are "recalculated" on item create/edit with TODAY() so you might experience some issue so rather hardcode the correct value like YEAR(2O23) or YEAR([Created]+1) might be more suitable.

Source Link
Popkornak
  • 163
  • 3
  • 14

If the field is not required to be editable in the future, you can simply create a new calculated column, set as date with this formula:

=DATE(YEAR([Created])+1,MONTH([Created]),DAY([Created]))

Where instead of [Created] you can add your column name.