I want to take a string and turn it into a date but I cannot find the format how to enter the text so it is recognized as date. Please see the screenshot.
An answer can be found here. They key is to not use the magic variable directly in "Use date", but select "Given date" and then use the magic variable for that. This way a format can be specified.