Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SSRS date time error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All;

    I am using CRM 2013 fetch xml report in which i get the below date time error

    Any help much appreciated

    Thanks

    Pradnya07

    Friday, October 24, 2014 2:57 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    I think you can just format the datetime parameter to remove time from parameter. That is causing issue.

    Would you please try to download the fetchxml from advance find and compare the format of dates with SSRS report fetchxml? I think it is assuming date as 12 as date and 31 as month. 

    Thanks!


    • Edited by Kalim Khan Sunday, October 26, 2014 12:22 PM
    Sunday, October 26, 2014 12:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Please check that the date format in CRM database and fetchxml parameter are same. Please make sure that date format in filtering should be same.

    Regards, Saad

    Monday, October 27, 2014 12:46 PM