1 Reply Latest reply: Feb 11, 2014 7:35 AM by Hartley Julian RSS

    Date where clause odd behaviour...

    Hartley Julian


      Hi All,

      I have a strange situation in my load script. All that I am doing is filtering on a specific date using the following logic:

       

      let vCurDate = date(peek('%keyDate'),'DD/MM/YYYY');

       

      Load

           *

      resident Temp

      where %keyDate = '$(vCurDate)';

       

      Now, even though there is data, the above returns no results. HOWEVER, if I put > rather than = in the where clause then it does return the date equal to that date (and above of course).

       

      Can anyone help explain this strange behaviour?

      Thanks!