7 Replies Latest reply: Jan 28, 2015 9:21 PM by jagan mohan rao appala RSS

    len & isnull don't work correctly

      Dear QV users,

       

      I have a date field in a QVD file. I have used the isnull en len fuction as you can see below. The only result I get is that it recognizes the field with date and gaves me a "NO" result. When a date is not filled it does not put yes on the field StatusLimisExWork (see below). When I dump the table to excel it has no data on field pj_leverdatum.

       

       

      LimisData:
      Load
      ord_ext_ordnr as JOB_NUMBER,
      pj_leverdatum as LimisExWork,

      IF(len(trim(pj_leverdatum))='','YES','NO') as StatusLimisExWork,
      FROM
      [..\Data\QVD\Salesprognose.qvd]
      (
      qvd);

       

       

      Can someone help me please with this :-).

       

      With kind regards,

       

      Aissam