3 Replies Latest reply: May 15, 2014 10:02 AM by kolz _ RSS

    Help with Date Conversion

    kolz _

      Love Monarch.  using V.9

       

       

       

      I have reports that present dates in the following format:

       

      20080610      Need it to convert for export to acceptable Excel date 06/10/2008 and recognize it as a date field

       

      My guess is i have to create a calculated field.   But what are the right formulas and right language/function.

       

      Appreciate your assists in advance.