1 Reply Latest reply: May 15, 2014 9:58 AM by Gareth Horton RSS

    An Amusing Date Limitation

    Mark Huston

      A low-priority sidebar:

      We use reports which contain expiration dates as text strings. In some situations, the report uses "12/31/2999" to indicate "no expiration date". I used CTOD on this string and it returned "-". After some trial and error, I found that Monarch returns a date for CTOD("12/31/2100") but returns a "-" for CTOD("01/01/2101"). So for those of you planning for the 22nd century, you might want to keep this in mind!

        • An Amusing Date Limitation
          Gareth Horton

          Mark

           

          That's true.  V6 and earlier only supports dates until 2100.

           

          V7 supports dates between 1601 to 2400.

           

          This is still not enough for your year 2999 data, but should be enough to deal with lifespans of people born for the next few years.

           

          Gareth

           

          Originally posted by Mark Huston:

          A low-priority sidebar:

          We use reports which contain expiration dates as text strings. In some situations, the report uses "12/31/2999" to indicate "no expiration date". I used CTOD on this string and it returned "-". After some trial and error, I found that Monarch returns a date for CTOD("12/31/2100") but returns a "-" for CTOD("01/01/2101"). So for those of you planning for the 22nd century, you might want to keep this in mind! [/b][/quote]