Hi
I am trying to ensure the dates in this query are in the date format but I keep getting an error.
I have split the cells, made them numbers, merged them and then changed to date format, trimmed the data but when I go to load it, it is coming up with an error in the date fields.
This is the error -
DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 1/2/2016 1
I have attached an example file.
Any suggestions as to why it is doing this would be appreciated. Thanks.
Hi Karen,
There are several date fields in the sample file, I don't know which one you're working with or how you've tried to parse the data. Please upload the file containing your query so we can see where things may have gone awry.
Thanks,
Mynda
Hi Mynda
The sample file I uploaded has the query in it and the error file. It is the column named "Date" in between the "Please enter your email address" and "Please select the class that you have attended" columns in the file. Hope that helps.
Thanks. Karen
Hi Karen,
Thanks for clarifying. Sometimes when I download Excel files the queries are being removed. I downloaded it again and I can see it now. That's the price I pay for using a beta version of Excel!
If you look at row 57 of your query back at the 3rd step; Split Column by Position, you'll see there is a trailing 1. You need to remove that step and then split column by delimiter and use the space as the delimiter and once as far left as possible.
Mynda
Thanks Mynda. Such a simple thing...damn it!
Thank you again. 🙂
