Two digit year in textfield

[freecolours]

I have a problem with a text calculationfield. The field is named 'OrderID' and contains this calculation:

CustomerID & " " & Year(today) & " " & OrderID

The Year shows 4 digits, but what I would like is that the Year shows 2 digits in the field.

Is there a soluton for this?

[laker_42]

Try this:

CustomerID & " " & Right( Year(Today),2) & " " & OrderID

It will give you the last two digits of the year.

John

[freecolours]

Thanks John! It works great!