I am trying to reformat the datetime column into just date and date and time separately but getting below error when I am trying to cast the values.
Some of them are working with no issues:
But some are throwing NaN values:
It looks like the day and month are parsed in wrong columns.
Hey @techfitlab if you're still looking into this, our Office Hours could be a good format for exploring what's going on with converting those dates, and get ideas in a group including Retool Community Support Engineers and other experts from the community 
If you do join an Office Hours session, could then share learnings back here as I'm sure it could be useful for others searching for how to build similar functionality!
If you do join an Office Hours session, could then share learnings back here as I'm sure it could be useful for others searching for how to build similar functionality!
