+ Start a Discussion
StefanStefan 

RevenueForecast Start Date greater than 31/12/2007 ERROR

I get a message reading:
 
id from RevenueForecast where StartDate > 2007-12-31T00:00:00.000Z
value of filter criterion for field 'StartDate' must be of type date and should not be enclosed in quotes
 
This used to work!
 
 
IWyattIWyatt
I would assume that you've tried formatting the date as 12/31/2007?
 
You may also want to set Excel's cell format to 'text' (not 'general'  or 'date') and see if that produces a different result.
 
 
 
IW
StefanStefan
Thanks for your suggestions, unfortunately still can not get this to work!
AdminisaurusRexAdminisaurusRex

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.

IWyattIWyatt

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:

 

LEADCreateddate>2009-04-15
LEAD IDFirst NameLast NamePhone

 

Hopefully, this works with your setup.

 

IW

Message Edited by IWyatt on 04-23-2009 12:02 PM
StefanStefan

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 

 

 

AdminisaurusRexAdminisaurusRex
Darn. That is sad. Oh well. Thanks for your replies.  If I hear anything or figure it out, I'll post back here.
Riley BRiley B

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.

 

BritishBoyinDCBritishBoyinDC

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