How to convert date format YYYYMMDDTHHmmss to YYYYMMDD in quicksight i have try using edit date formation it is taking it as buydefault that format only an with formatdate creating column i am getting that as string datatype i need it as date onl-y

[Kavtya]

[Giridhar.Prabhu]

Hi @Kavtya

I see you have mm for month in the format. Change it to MM and validate and confirm to see if that resolves your issue.

Regards,
Giri

[Kavtya]

@Giridhar.Prabhu Hi it is still the same after that

[Giridhar.Prabhu]

Hi @Kavtya

The recognized now shows 06 which was earlier 01. What happens when you click Validate or Update?

Regards,
Giri

[Kavtya]

@Giridhar.Prabhu i have try it but still

my date is moving forward by 1 day in line chart

[Kavtya]

[Giridhar.Prabhu]

Hi @Kavtya

If you do Edit > Analysis Settings you have a timezone property. What do you have there?

[Kavtya]

Hi @Giridhar.Prabhu i have SOS access of quicksight i am not sure where to check the setting

but the region is selected as Mumbai

[Giridhar.Prabhu]

Hi @Kavtya

The time-zone property is in the Analysis. Open the Analysis and do Edit > Analysis. Based on your location I am assuming the data from the datasource is actually in Indian Standard Time. But when you save the dataset it is treated as UTC. You will have to set your time-zone as Asia/Kolkata

I think that should fix the issue.

Regards,
Giri

[Brett]

Hi @Kavtya,
It’s been awhile since last communication took place on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Kavtya,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!