Skip to main content

in date filter if i select 15 august 2016,then in report level it shows data of  15 august 2015 i.e 365 days...plzz help me out in getting this logic.

 

Thanks in advance.

답변 4개
  1. 2016년 10월 20일 오전 6:42

    Try something like this

     

    Create a parameter including dates from date field

     

    Try something like this Create a parameter including dates from date field datediff('day',[Order Date],[Date parameter])=0ordatediff('day',[Order Date],[Date parameter])=366 Thanks

     

    datediff('day',[Order Date],[Date parameter])=0

    or

    datediff('day',[Order Date],[Date parameter])=366

     

    pastedImage_0.png

    Thanks

0/9000