i want to put date format in auto ID

[riazbhatti81982]

i want to create an auto ID in my database using date format
e.g
20181009-00001
20181009-00002
20181010-00003
20181011-00004

 

[helpstar]

Which database are you using?
Access/Excel , SQL,...?

 

[riazbhatti81982]

Which database are you using?
Access/Excel , SQL,...?

i am using access based database

 

[helpstar]

Maybe like this
https://stackoverflow.com/questions/24312900/automatically-generate-date-4-digit-sequence-number-for-id-in-access-2010