How can I say this ?

Code:
INSERT INTO table SET nr=MAX(nr)+1 WHERE date='xx.xx.xx xx:xx:xx'
nr is not primary, so I can not use auto increment.