Display The last digit of a year

[Kevbro7189]

I have a table with a Date/Time field in it. I use this table to fill out a
form on which I use that date. On the same form I need to enter in a block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8

 

[Brendan Reynolds]

I have a table with a Date/Time field in it. I use this table to fill out
a
form on which I use that date. On the same form I need to enter in a
block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8

=Right$(Year([Acquired Date]),1)

Replace "Acquired Date" with the name of your Date/Time field.

 

[Kevbro7189]

Thank you. it works!!!!

I have a table with a Date/Time field in it. I use this table to fill out
a
form on which I use that date. On the same form I need to enter in a
block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8

=Right$(Year([Acquired Date]),1)

Replace "Acquired Date" with the name of your Date/Time field.