Skip to Content
0
Former Member
Nov 19, 2007 at 06:21 PM

Two-digit Year

556 Views

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.