Not able to format the date type to yyyy-mm-dd

Q&A
,
1

20260102_154709
20260102_1547091536×3977 1.91 MB

I have a date type field in dataset when it is used in visual. I am not to set the format to yyyy-mm-dd Want to dispaly dates like this 2026-01-03. In dataset also the data is like this only

2

Hi @Tanu_13

Create a calculated field using formatDate function. This converts the date to a string in the exact format.

Example: Note - Replace with your actual date field

formatDate(Datetime, 'yyyy-MM-dd')

Refer the document for supported date formats - Supported data types and values - Amazon Quick Suite

image
image532×298 18.1 KB

3

@Xclipse This particular date field is used in Incremental refresh for setting window size. Does using calculated field affect the performance of refresh.

4

Hi @Tanu_13

No, using a calculated field like formatDate for display does not affect the performance of incremental refresh. Incremental refresh relies on the original timestamp/date field from the source to define the look back window, not derived fields.

5

Hi @Tanu_13 ,

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Suite Community Q&A Forum!