Using timeseries you still need to convert your date to a string and use the scatter type. Make sure to export your date to a string with format yyyy-MM-dd.
So
formatDateTime($date, 'yyyy-MM-dd HH:mm:ss' )
Edit: this answer only applies when using the anychart widget