in dataflow, the select transform shows columns.
some of them are date columns but datapreview shows as string because they are coming in from .json files.
I would like to convert the date columns to date datatype
the sink at present is delta parquet
When I try to convert the date string to date, I see null in datapreview of derived column.
This is what I am using in derived column: