3 Replies Latest reply on Mar 13, 2015 2:26 PM by Ahamad shaik

    Week of Date Calculation

    Ed Kukec

      Hi All,


      I'm trying to display my data in my dashboard weekly so that it reads something like this:


      2010 Week of Jan 1,

      2010 Week of Jan 8, etc.


      When I use the following calculation:


      DATENAME('year',[Date])+" Week of "+STR(DATETRUNC('week',[Date]))


      I get: 2010 Week of 01-01-2010 00:00:00 or something rather.


      How do I get the above format in my calculated field?