Hi @GrantSmith ,
This is the date format I have in the dataset :
I wanted to remove the C and have it in text to alter it as Date :
Thus I used this formula on the formula tile (RIGHT(Date
, 10)) and got it in :
However I tried using the Alter tile and Formula tile (STR_TO_DATE(Date
, '%Y-%m-%d')) which did not work, giving me this error message below :
Appreciate your kind help!