Hello,
I would like to understand why date fields in QuickSight 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, QuickSight add a time section whereas in my data source, there is no time.
@Valentin_Davy QuickSight 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