Date datatype gets converted to String (not able to change it)

Question & Answer
1

Hi Team,

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?

Thank you!

2

@QuickSightRokie there might be some invalid values stopping that.

you can also use parseDate() as custom field in quicksight

3

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?

4

@QuickSightRokie Yes, I am suggesting using calculated_field.

5

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

6

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.

1 Like
7

you can use multiple functions within the calculated field… You don’t have to use the calculated field

8

@QuickSightRokie

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.