Getting a 2 digit year

[jlindquist]

I have a text box which holds a project number. There's an autonumber on the field and I need to attach some more info to make it a correct project number. I know the format of attaching text on something & "whatever", etc. but I just want to get the 2 digit year to attach on the end. How do you format the date or Year(myDate) to get that?

 

[JoeMiller]

If you want to get the two year value of todays date you would use this equation:

format(Date(),"yy&quot

HTH Joe Miller
joe.miller@flotech.net

 

[jlindquist]

Thank you for your help...worked like a charm