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

  • Question


  • 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

  • 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
  • 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