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

    Converting character field to date field

    PAStoddard _

      I have a date on a report that looks like:  18-JUL-2008

      I can extract the day, month and year into three separate columns.

      Then I convert the month to a number.

      I can then combine the three fields (New month integer format C2, day D2, year E2) in Excel to get the short date format by using the formula =C2&"/"&D2&"/"&E2.

      The idea is to create a calculated field in Monarch to produce a date type field.

      What formula will produce this in Monarch?