nightowl

Calculate Week Number in Formula Field

Calculate Week Number in Formula Field

Hello - I have a field in my table that has a Formula Field. I need help to generate a formula that will give me the week number based on my TimeStamp field.  
Hi NeoInJS,   Please try using this formula: FLOOR(     (         DATEDIFF(day, CONVERT(datetime, CAST(DATEPART(year, [@field:Start_Time]) AS CHAR(4)) + '-01-01', 101), [@field:Start_Time]) +          (             7 -              (                 (                     (                         (                         DATEPART(day, [@field:Start_Time]) +                          FLOOR(13 * ((CASE WHEN DATEPART(month, [@field:Start_Time]) &l