How to make a default value of the current year

[Marco]

Hello.

I'm trying to make a default value of the current year for a specific field.

I'm trying to use this: Right((Now();'Short Date');4) but when I'm
saving is not working.


What's wrong?

Regards,
Marco

 

[Rick Brandt]

Hello.

I'm trying to make a default value of the current year for a specific
field.

I'm trying to use this: Right((Now();'Short Date');4) but when
I'm saving is not working.


What's wrong?

With your expression? Just about everything

Just use Year(Date())

 

[BruceM]

"Short Date" works with the Format function. Your use of it in the Right
function is not going to do anything, AFAIK. The Year function is a better
way of extracting the year portion of a date: Year(Date()), but if you
already have the date in the record there is no need to store the year also.
Just use the Year function when you want to display the year.