You need to sign in to do that
Don't have an account?
Stefan
RevenueForecast Start Date greater than 31/12/2007 ERROR
I get a message reading:
id from RevenueForecast where StartDate > 2007-12-31T00:00:00.000Zvalue of filter criterion for field 'StartDate' must be of type date and should not be enclosed in quotes
This used to work!
Did you ever get this problem solved? I am running into this issue now. Very frustrating. I have tried all iterations of cell and date format possible.
Please let me know if anyone figured this one out.
It might depend on your API version and the object you are trying to query, but I have found that typing it in this way, (regardless how the format LOOKS), works well: 2009-04-01
So for example construct your excel connector query as such:
Hopefully, this works with your setup.
IW
I never did solve the problem.
Subsequently I have been using Demand Tools and DB Amp and therefore no longer need to use the Connector
i have the same problem
"must be of type date and should not be enclosed in quotes"
and then the excel connector disconnects and i need to log in again.
If anyone else ends up here, this seems to work:
for 12/31/2009, use the date formatted like this:
2009-12-31T00:00:00.000Z