I have a problem. I have a dataset with one column date, but unfortunately this is a string. I wanted to use the node string to date, but it fails, with the following error:
@Sander_vdv you could enter a proper sequence of placeholders (DateTimeFormatter) yourself. You should check some special cases within your data (eg 29th of February if it is occurs).
@Sander_vdv - first of all, you selected “Date” in New Type, but the Date Format is a Date&Type. You need to setup a Date format compatible. For the your data - ‘21/9/20’ - the correct format would be d/M/yy. I tried and this setup worked. You can see bellow how i configured the node.