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.



      ord_ext_ordnr as JOB_NUMBER,
      pj_leverdatum as LimisExWork,

      IF(len(trim(pj_leverdatum))='','YES','NO') as StatusLimisExWork,



      Can someone help me please with this :-).


      With kind regards,