I am attempting to create a dashboard with the data source file being an excel spreadsheet. During the data up load into QS during the data edit review, I have noticed that QS isn’t recognizing the columns from the excel file that are in the date format. When I edit the data using the QS data editor to Date format the data uploaded returned is Null. I have tried ensuring that the date fields are sorted to ensure there are no blank rows at the top and using the Date and Date time format options in both excel and QS without success. I have tried the parseDate function as well with no luck.
I should add that the format in Excel file is MM/DD/YYYY and preview in QS is MM/DD/YY
Hi @orlinder,
From my experience using dates or other formatted fields from Excel sheets, Quick will usually handle it as a string (or handle it in a way usually not what is intended). Let me know if I am misunderstanding, but I see in your last picture that one of the cells has a format of MM/D/YYYY? If so, I am wondering if fields like that are the reason Quick is giving that warning. If not we can definitely double check if there are any methods with parseDate or other workarounds!
1 Like
The format in excel is set to MM/DD/YYYY. I actually discovered last night while continuing to deep dive this that the solution was to change the format in excel to ‘YYYY-MM-DD which is the standard format in QS. Once I made this change and re-uploaded the data it registered as a string but allowed me to change the data type in QS manually.
