Hello,
I would like to understand why date fields in Quick Sight are formatted by default as a complete timestamp (dd/mm/yyyy HH:mi:ss).
Is it possible to have only the date format (dd/mm/yyyy)?
Thank you for your reply.
Best regards,
Valentin
1 Like
Hi,
You can select the more formatting options and remove the hours, minutes and seconds. Sample screenshots below.
Hi @agmayan,
Thank you for your reply.
I meant in the data set creation screen.
Each time I’m working with dates, Quick Sight add a time section whereas in my data source, there is no time.
@Valentin_Davy Quick Sight data type is of datetime, so we append it automatically. I’d love to understand the issue this is causing to your use case.
Thank you for your reply @shailesh !
It can be disturbing to see hours displayed (even if it’s “00:00:00”) when the source field is just a date.
Do you think this default formatting of datetime will be a little bit flexible and add a simple type date?
Yes, agreed, it is an annoyance. We do plan to add just date as a data type format in the future.
1 Like