How to show year as 2 digits in a text box

[tbac]

I would like to have a text box that would display "07" in 2007 and "08" in 2008, etc. I though I could simply have =Year(Now()) formatted yy. But that doesnt work. I know that if you were to format Now() as mm/dd/yy it would show the year as "07" but you would have the rest of the date as well and I just want to show the year.

 

[PHV]

You may simply try this:
Format(Date(), "yy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886