12 Replies Latest reply: Aug 4, 2015 7:37 PM by Paul Scotchford RSS

    Strange data formatting behaviour

    Paul Scotchford

      Using the following formatting option in the Date() function , the Full Day is truncated and part of the year number is appended ...

       

      Function ... Date("Date", 'WWWW') as FullDayName

       

      Data ...   30Jun2015 = Tuesday015 ,  1Jul2015 = Wednesda15 , 4Jul2015 = Saturda15

       

      Days of Sunday, Monday, Thursday, Friday are returned as expected.

       

      Has this been noticed anywhere by anyone? Normally I don't generate the days this way, we load directly from a

      SQL date dimension which has full days predefined.

       

      Thanks

      Paul