Default Year 2 digit

  • Thread starter Thread starter Shane L.
  • Start date Start date
S

Shane L.

I am setting a default value in a field using the Year
function. I need to show only the 2 digit year not 4
digit. Here is the code I now have in there.

=Year (Date())

I don't won't to change the date settings in Windows if
all possible. Can someone please help
 
I am setting a default value in a field using the Year
function. I need to show only the 2 digit year not 4
digit. Here is the code I now have in there.

=Year (Date())

I don't won't to change the date settings in Windows if
all possible. Can someone please help
Click to expand...

If this is an Integer or Long Integer field rather than a date, and
you want this year to go in as 3 (and four years ago to go in as 99),
use

=Format(Date(), "yy")
 
Back
Top