7 Replies Latest reply: Jul 8, 2009 4:07 PM by misterminit RSS

    Connector: problems with the date format with null values

    misterminit

      Hello,

      I'm using the SAP connector to download datas. There is a field with a date. If the values are filled, QV identifies it as a date and I can change the format to e.g. DD.MM.YYYY.

      But if there are no values (the date is null) QV ingores the set date-statement. All values they are filled are set as a date, the null-value is filled with a date, formated in the system format e.g. 0-0-0000, straightened as a text.

      A workaround is to load the date like

      date(LAEDA,'DD.MM.YYYY') as LAEDA

      but this isn't practicable.

      Any other ideas?

      Greetings

      MM