How to add auto incremental id for Deals

How to add auto incremental id for Deals

Hi everyone,

I've been trying to implement a way to identificate every Deals created within my enterprise with a similar and easy readable pattern.

Something like : YEAR.MONTH.xx

Where the first Deal of the month would be 2019.10.01, the second would be 2019.10.02 etc

And when starting a new month, it would be 2019.11.01 (starting at 01 again)

Is there some way to achieve that ? I've been trying to use the autonumber field and some formulas without success..

Thanks a lot.