I'm attempting to export a record/report as a CSV or save the same as a spreadsheet so I can use formulas in my "Sheet 1" to reference the exported cells in "Sheet 2." The problem I'm running into is that QuickBase seems to randomly change the format of the date when it appears in Excel. I've tried inputting dates via typing/manual input and selecting dates from the calendar button and then exporting to see if that makes a difference. I've found that it does, but in one column, the format is mm/dd/yyyy and in another column it exports as mm-dd-yyyy. Other issues I've run into are it exporting as dd-mm-yyyy and various other date formats, which are useless unless I manually change the cell date format in Excel for each export. I've attached a PDF that illustrates what I'm talking about. I need QuickBase to export in a consistent format, preferably dd/mm/yyyy. Thanks.
I think what is happening is that plausible but incorrect dates are being treated as dates and the implausible a one like month number 13 are being treated as text.
I'm not at a Windows computer now, so I can't give you the exact steps, but maybe google words default date format.
Are you UK based (or at least, somewhere where the "normal" date format is DD/MM/YY)?
You can set your application to use DD/MM/YY (In APP Settings | APP Properties | Formatting | Dates) so that the date order inQB is as required, but more importantly Excel exports are correctly formatted. We've suffered with this for years in our apps, and still have legacy apps where this is an issue.