Currently in DataPrep UI we offer a variety of date formats that the user can use to parse a Date type column. However some of these are not working. These are:
- MM-dd-yyyy 'at' HH:mm:ss
- MM.dd.yyyy HH:mm:ss.SSS
- EEE, MMM d, 'yy
Attached is a gif of trying to Format date using the first one listed above.