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.