Good day All ,

I have a situation where i needed to add the year of the transaction to the invoice number and that was fairly easy to accomplish. However , The company in which i am creating the report for seems to bill customers on a bi-weekly basis and the invoice numbers they use are formatted as for example :
                                       HOT157-1
                                       HOT157-2
                                       HOT157-3
With the inclusion of the year the invoice number looks like HOT157-12017.
Is there a way to get the first invoice number which would naturally be HOT1572017 rather than having the number for the other invoices regarding that customer ?


Any help would be appreciated .

Regards,
Teddy

Well it is not pretty, but I think this might work.

left({somestring},instr({somestring},'-'))+right({somestring},4)