How do you remove extra characters in a date column? I can see how to change the date format, however the date is still too long and includes time. I want to remove the time and only have MM-DD-YY. Thanks!
Hi @anneshie
Thanks for your question!
You can create a calculated field with formatDate function to format the date like (MM-dd-yyyy).
Example :
formatDate({Your Date Field}, 'MM-dd-yyyy')
Please refer the below supported date format documentation this might be helpful for you.
1 Like
Thank you for your help, I continue to get errors and it looks like the source date format is unsupported, however when I view the date field upon export, it appears to be ok. I’m not sure what to do except modify it before the data is imported into QuiskSight.
Hi @anneshie
If the source date format is causing issues, modifying the data before importing it into Quick Sight is a good approach.
If you’re using a Excel, SQL, or a data preparation tool, you can format the date column before importing it into Quick Sight.
For example, in SQL, you can use a CAST function to convert the date to the desired date format.
1 Like