AnsweredAssumed Answered

Formula Help for Invoice Number

Question asked by Hybridnath on May 17, 2010
Latest reply on Apr 6, 2013 by MICHAELAE-V


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.