5 Replies Latest reply: Jun 25, 2013 7:39 AM by Nigel West RSS

    data showing one day ahead of selection

    Gaurav Khare

      Hi,

      I have created a query showing date range and presenting it in two calendars, one is for 'FROM DATE' while the other is for 'TO DATE' and used two variables for this purpose. The problem I' am facing is that if I select date from 20th June to 25th June, the data it is showing for 26th June also though I have used <=

      Can anyone suggest where I' am going wrong with the above. The expression is like:

      =if(date(FinalDate) >= date(vStartDate) and date(FinalDate) <= date(vEndDate+1), date(FinalDate, 'DD/MM/YYYY'))

      Please suggest

       

      Regards