I am encountering an issue where the datatype in excel is “Date”. But when I import the excel spreadsheet in QuickSight, it changes to “String” datatype. After that while importing the spreadsheet in QuickSight, I tried converting to “Date” datatype but it does not allow me to do it.
What is the best way I can resolve this?
@QuickSightRokie there might be some invalid values stopping that.
you can also use parseDate() as custom field in quicksight
Thank you @nshah-quicksight !
I believe you are recommending to use it as a calculated field. Correct?
If yes, I think we will not able to use calculated field under a calculated field. Correct?
@QuickSightRokie Yes, I am suggesting using calculated_field.
Hi @QuickSightRokie - Can you please give sample data… usually you can convert the data to date with right format or the suggestion from @nshah-quicksight should work.
Regards - Sanjeeb
Thank you !
Using parsedate works but when I use the calculated field (using parsedate) is added to another calculated field, I get an error. Trying to resolve this.
you can use multiple functions within the calculated field… You don’t have to use the calculated field
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.