13 Replies Latest reply: Jul 5, 2017 9:53 PM by Jan Lederer RSS

    Time Compare Problem (SQL)

    Jan Lederer

      Hi Everyone,

       

      I'm getting crazy because - I guess - a small problem:

      I import Data from a SQL-Database with OLE-DB - there is a data field (Date) with the format DD.MM.YYYY hh:mm.

      My settings look like that:

       

      SET TimeFormat='hh:mm';

      SET DateFormat='DD.MM.YYYY';

      SET TimestampFormat='DD.MM.YYYY hh:mm';


      In another field a got some Entries per Month (SU_TIME) over 3 years.

      Now I just want to show the average per month with AVG() and select one year as following:

       

      AVG ({$<Date={2015}>}SU_TIME)

      Dimenson is just Date.

       

      The diagramm won't show any data to me.

      Even simple if-statements do not work with Date ...


      Hopefully you can help me!

       

      Thanks a lot,

       

      Jan