Two-digit Year

Post Author: ltidquist

CA Forum: Formula

I have a formula that's not quite right. I need this to return just the two-digit year (07) for a datetime field.

totext(Year({Subscriptions.BILL_BEGIN}),0,'','')

This is returning the four-digit year (2007)

What am I missing?

Thanks in advance.