5 Replies Latest reply: Apr 27, 2016 2:46 AM by Alluraiah Allu RSS

    Min and Max not working for dates

    Alluraiah Allu

      Hi,

       

      I am unable to get the variables   fdate and tdate  in to the CALENDAR objects ..

       

      Is there any syntax error ?

       

       

      LOAD * INLINE [

        Country, Value, SalesDate

        USA, 12, 2013-01-04

        USA, 14.5, 2013-02-07

        USA, 6.6, 2013-03-03

        USA, 4.5, 2013-04-11

        USA, 7.8, 2013-05-19

        USA, 9.4, 2013-06-22

        UK, 11.3, 2013-01-31

        UK, 10.1, 2013-02-01

        UK, 3.2, 2013-03-2182

        UK, 5.6, 2013-04-15

        UK, 3.9, 2013-05-12

        UK, 6.9, 2013-06-06

      ];

       

       

       

       

       

       

      Let fdate = MIN(date#(SalesDate, 'YYYY-MM-DD'));

      LET tdate = Max(date#(SalesDate, 'YYYY-MM-DD'));