Invoice number based on Year
I just created my first database with FM (an invoicing solution) but got stuck.
Each of my invoices should contain the year (2-digits) in which it was issued followed by a 3-digit serial number, i.e. the first invoice in 2011 would be: 11-001.
How can I get the current year and then add the automatic increment? After one year has passed, the increment should start from zero again, of course.
If anyone could help, that would be great.