Last Modified Date: 15 Sep 2020
- Tableau Prep 2020.2.1 and later
Make sure that the date field in the original data source is configured to have date as a Data type
Use Custom SQL: Cast the data type as Date for the string recognized column
SELECT "SuperStore_Orders"."Order ID" AS "Order_ID",
CAST("SuperStore_Orders"."Order Date" as date) AS "Order_Date" from "_SYS_BIC"."SuperStore_Orders" "SuperStore_Orders"
CauseIn the DB, Fields having values like 20200807 are interpreted as a String instead of date and the requirement for incremental refresh to be enabled is field must be assigned a data type of Number (whole), Date, or Date & Time
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials