Formula Help for Invoice Number
I am in the process of moving over to FileMaker Pro 10, which is great. Previously on my Invoice numbers I follow the Year and Month then number the invoice.
E.g. The first 2 invoices in April 2010 would be 100401 then 100402. May then becomes 100501, 100502, 100503 and so on.
I have tweaked the invoice from the template, and this is one of the last areas I am struggling with. Can anyone suggest how to do this please.
Many thanks in advance.