Forum Discussion

KeithS1's avatar
KeithS1
Level 3
5 years ago

Retention category - month - is it 28 days or a calendar month

Hi, I need to setup a new archiving policy and have been asked to set it to 14 months retention plan - this means 1 year and 2 calendar months (1 year and 60 days). When I specify the month period, ...
  • ChrisLangevin's avatar
    ChrisLangevin
    5 years ago

    I can confirm it uses a calendar month. It's built on the SQL DATEADD and DATEDIFF functions, with the datepart argument set to month.

    --Chris

GertjanA's avatar
GertjanA
Moderator
5 years ago

Interesting question. I've tried location info on that, but could not quickly. I do believe that if you select 14 months, it will obey the days in the month. Let's see what others find.

  • Prone2Typos's avatar
    Prone2Typos
    Moderator
    5 years ago
    I believe it to be calendar month not a number of days.
    • TonySterling's avatar
      TonySterling
      Moderator
      5 years ago

      I too believe it goes by calendar month.  A lot of customers I have worked with use number of days.  For example, instead of a 18 month retention they standardize on 540 days.  That way it is more predictable for them and it removes the ambiguity.