Can you provide an example of where you feel you need to pull out a dagger as a wizard?
It does sound like the OP misunderstood the wizard class table and thought the number of cantrips was the number per day rather than the number you know and can cast at will.However, even with cantrips (new to me) we still have a few spells and then pull out the ole dagger!
one thing you may not forget: dual daggers may end up being more damaging than a can't rip at low levels, but only if you have higher dexterity than int.
Why can't WotC/D&D create a spellcaster, specifically a wizard, who never needs to resort to weapons like swords and bows? I played the basic rules boxed set in the 1980s when the Magic-User got one magic missile and then had to use a dagger for the rest of the adventure. I was recently excited to start playing again with my kids and 5e, which I like in general. However, even with cantrips (new to me) we still have a few spells and then pull out the ole dagger! Same is true for warlocks, sorcerers, etc. It is easy to play a Barbarian or Fighter with no spells and many types of creative combat maneuvers, why not all spells for the wizards?

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.