1 of 1 people found this helpful
Is the issue with the date, or just connecting to the file?
If the date, you are going to need a calculation like:
That works, thanks Alex for the quick response and detailed help!
Please try the DATEPARSE function. You can pass the format string to the function and it will convert your string into a date. Availability depends on the database, if your database doesn't list DATEPARSE as a function when connected live, you can get it still by creating an extract.