4 Replies Latest reply: Oct 6, 2014 7:22 AM by Ashfaq Mohammed RSS

    Specific Date = Now

      Hi,

       

      In my load script I am loading from a qvd file and I have a column called RL.CALL_DATE_RECD which shows the date when a call was logged.  At the end of my load script I have a where clause and I want to do is bring up all the cases where the RL.CALL_DATE_RECD = Todays Date.

      I have tried WHERE DATE(RL.CALL_DATE_RECD = DATE now()), however none of my date is showing.

      Would someone be able to help with this please?

       

      Regards,

       

      Jon Ditchfield