6 Replies Latest reply: Dec 8, 2014 4:15 AM by Colin Albert RSS

    Date problem/bug

    Filip Larsson

      Hi everyone,

       

      I have now experienced a problem with dates that I have never seen before... I get different date values in the load of my fact table, even though I use the Date() function, and it's the same source. It's also the same date format in this source, and there are only a few transactions that gets "another" date. I can point out that fact when selecting two different values (of the same date in my current selections:


      current_selections.JPG.jpg

       

      Here is my code:

      Fact:

      Load

          RecNo() As Recno,

          Date(MyDate, 'YYYY-MM-DD') As Bokföringsdatum,

          ... more fields ...

      FROM MySource.qvd (qvd);

       

      Calendar:

      Load

          Date(ISODate, 'YYYY-MM-DD') As Bokföringsdatum,

          Year(ISODate) As MyYear,

          Month(ISODate) As MyMonth

      FROM MyCalendar.qvd (qvd);

       

       

      Of course I want only one value of my date 2014-01-31... As it is now, only one of these values matches to my Calendar table, and the transactions with the "wrong" date format, doesn't get Year or Month values...

       

       

      I hope you can understand my problem, and hopes of any solution to this.


      Best regards,

      Filip