Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Unrecognized 'Edm.DateTime' literal 'datetime'2014-04-17T00:00:00 01:00'' in '63' RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote


    What on Earth does the message "Unrecognized 'Edm.DateTime' literal 'datetime'2014-04-17T00:00:00 01:00'' in '63' mean?

    I think this is being returned from CRM. I see it in a thread from a silverlight application as the error message returned by CRM from a search filtered by the results of a DateTimePicker in a silverlight CRM application. It does not occur in development but only in the deployed application. My initial guess is that it has something to do with timezones or daylight savings but all machines in both development and deployment are in the same timezones with the same daylight savings applied.

    For that matter what is an 'edm.datetime'?

    Ta

    Thursday, April 17, 2014 1:45 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    IMO you are using the wrong format on the DateTime field.

    Try printing your DateTime field and check it`s format.

    • Proposed as answer by tiagolvsantos Thursday, April 17, 2014 4:48 PM
    • Unproposed as answer by tiagolvsantos Thursday, April 17, 2014 4:48 PM
    Thursday, April 17, 2014 4:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    There is no formatting. It is returned from a silverlight control as a DateTime value and then passed into a LINQ query as a datetime value. i.e.

    var query = from c in config.context.IncidentSet
            where c.CreatedOn.Value >= dtfrom
            where c.CreatedOn.Value <= dtto
            select c;
binding.LoadAsync(query);
    It is never touched or formatted at any point along that chain and yet it works on one box and fails on another. I suspect you're right but something else is formatting it and breaking it.


    Thursday, April 17, 2014 5:18 PM