First off, your table structure needs fixing. It is NOT normalized. You are using a spreadsheet approach with a relational database. You need to stop thinking short and wide (like a spreadsheet) and think thin and tall. You have repeating fields like tblQuantityOrdered, tblQuantityOrdered_2, tblQuantityOrdered_3, etc. and more like that. You need at least one, if not more tables and you need to use at least one, if not more, subforms to enter the data. And your quantity fields and price fields should be NUMERIC, not TEXT.
And your date is working fine as long as you enable code and macros. It will only put in the default date on NEW records, not existing ones. That's how defaults work. If you want something in an existing record that doesn't have a date, you need to manually enter it.