Generate a 16062801 format number based on the current date

A previous post: generate a number according to the date, and the link is as follows: http://plat.delit.cn/forum.php?m. Hlight=%B1%E0%BA%C5

Now the customer is asking for the first two numbers of the year to be removed; so how do you do that?

'query whether there is a contract number generated according to the current date in the contract order table

Dim htbh = ExecuteScalar ("select nvl (max (CTR_ID) + 1,'" + mid (formatdatetime (date (), "yyyyMMdd"), 2Len (formatdatetime (date (), "yyyyMMdd")-2) + "01') from CTR_CONTRACT where CTR_ID like'" + mid (formatdatetime (date (), "yyyyMMdd"), 2len (formatdatetime (date (), "yyyyMMdd")-2) + "%'")

The running effect is as follows:

Original address: http://bbs.delit.cn/thread-1103-1-1.html

Please indicate the source of the reprint:

Written by: measurement Technology http://www.delit.cn