I created my first DBI using one of Sverres articles on this topic.
The data is filled except 1 column, which is a date format column. All other columns are text, so this is pretty straight forward.
In the external database I have a value 31072008, which means abviously 31st of July 2008.
When creating the field, I chose the type Date.
My line of scripts says:
But I guess some logic or formatting should be added to import this date.
What should be the right formatting and syntax to change it?