Never ever do that. while it may appear to work fine, in a production environment it is a recipe for disaster as multiple users end up with the same value and your entire database very quickly becomes corrupted beyond belief.
Use an IDENTITY column in your DB, and let SQL sort out unique numbers. You can then use a subquery to return a incremental value per day by using PARTITION BY:
SELECT ROW_NUMBER() OVER (PARTITION BY EnterDate ORDER BY RowIDValueColumn ASC) AS DailyNumber, *
FROM MyTable
WHERE EnterDate >= '2016-02-02'
ORDER BY RowIDValueColumn ASC