Auto Unique Number on every REPORT

[imvineet]

Hello Everyone

I m VIneet from Delhi.. The issue is...

we have a database of arround 18K+ serial numbers of CPU, Printers Laptops Etc. every day there is a material movement (InComming and Outgoing from Ware house) in various implants.

The Report is generated from a Query in database in which we pull details for the material Going out or comming in.

I want there should be a unique Auto generated Delivery Challan Number whenever i generate a REPORT.

[weekend00]

you can use current time as a unique number

[imvineet]

you can use current time as a unique number

If we are using current time its comming with AM and PM. If you know how to change the formatt please let me know the steps.

Thanks in advance

[weekend00]

do you mind a 14 digit number:
format(now*10000000000,"0")