I think you need to change the one on your "generic_message_log" table for this line:
Date(floor([run_time]),'DD-MMM-YYYY') AS [Date],
You don't need to use "floor" in the one in the Calendar table as it doesn't have 'time'.
I'd suggest you have a look into this useful PDF, specially Tip 4 (page 5):
Hope it helps.