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?

       

      Thanks,

      Ed