5 Replies Latest reply: Jul 6, 2017 2:03 AM by Kamal Kumar Sanguri RSS

    how to define where clause for date

    vir vir

      Hi,

       

      I want to filter my LOad process with date.

       

      where createddate = 45678.7685   like that/...

      vToday=Date(Today(),'YYYYMMDD');

      Load Statment :

      LOAD Booking,

                 Booking Number

      FROM $(vQvdlaction)Booking.qvd(qvd)

      where Date(createddate,'YYYYMMDD')= $(vToday());

       

       

      but i am getting 0 outcome...

      but in data there are 50 rows with createddate =today()...

      PLEASE SUGGEST THE WAY TO CONVERT TIME IN WHERE CONDITION TO LOAD DESIRED OUTCOME.