To fix the date problem, go to the Warehouse tips, and look at the last tip "Get the correct date when exporting a section from BrioQuery to Excel."